topic How to group smaller values into a category in QlikView

How to group smaller values into a category

Fri, 19 Jul 2013 11:16:05 GMT

Hi everyone ,

I have a chart where I have a continuous line chart whose data is as follows

min , Value

20 , 50

40, 60

60, 10

80, 1

100,1

120,1

140,1

160,1

.

.

.

.

So it makes very rough line chart what I want is in my linechart there should be values like this

min , Value

20 , 50

40, 60

60, 10

80+, Sum of all values of >60 mins

How is this possible

Re: How to group smaller values into a category

Gysbert_Wassenaar — Fri, 19 Jul 2013 11:31:07 GMT

load if(min>60,'80+',min) as min, Value

from ...somewhere...;

or as a calculated dimension in your chart, i.e. instead of using min as dimension you use as calculated dimension if(min>60,'80+',min).

Re: How to group smaller values into a category

Fri, 19 Jul 2013 11:52:00 GMT

Thanks it works , Now I want to group these values by a step of 20 i.e. on xaxis labels will show 0,20,40,60,60+

20 will have value of count of all the events which occured between 0 and 20 and 40 will have value of count of all the events which occured between 20 and 40 and can I add min suffix which will make labels like this 20min,40min,60min,60+min ?