Skip to main content
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

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