Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

How to group smaller values into a category

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

2 Replies
MVP & Luminary
MVP & Luminary

Re: How to group smaller values into a category

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).


talk is cheap, supply exceeds demand
Not applicable

Re: How to group smaller values into a category

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 ?

Cont.PNG