Can we create a bins of numerical variable in Qlikview?

sort
qlikview

#1

Hi,

I want to show age wise distribution of total sales using a bar chart but here age is continuous variable. Can I convert Age into a multiple bins of age bracket 0-18,18-25,25-30,30-35,35-40, >=40. Another question, can I sort the dimension of chart based on expression?


#2

@Satish,

You can create bins of continuous variable using calculated dimension feature. Here use conditional statement “if” to generate bins as per your requirement.

You can sort the chart based on expression. Go to Sort tab and here you can notice that options available for expression. Put the expression based on which you want to sort the content of chart.

Regards,
Sunil