Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

Group: my data

Hi Community,

could  I Group TEMPO (measure) ?

>=0 AND <= 4

>=5 AND <= 8

>8

and so that.

Immagine.png

4 Replies
martinpohl
Partner - Master
Partner - Master

Change your TEMPO dimension to:

if(TEMPO<=4,'group1',

if(TEMPO<=8,'group2',

'group3'))

Regards

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

hi

tempo is a measure

and

group1

group2

group3

doesn't exit but

I would like to group columns 0 1 2 3 4 as a column A

I would like to group columns  5 6 7 8  as a column B

I would like to group columns '24 25 26 27 as a column C

parimikittu
Creator II
Creator II

Please try using interval match. https://community.qlik.com/thread/93656

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Create an extra dimension that groups the Tempo values into the groups you want. Then add that extra dimension to your pivot table above the Tempo dimension.


talk is cheap, supply exceeds demand