Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
could I Group TEMPO (measure) ?
>=0 AND <= 4
>=5 AND <= 8
>8
and so that.
Change your TEMPO dimension to:
if(TEMPO<=4,'group1',
if(TEMPO<=8,'group2',
'group3'))
Regards
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
Please try using interval match. https://community.qlik.com/thread/93656
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.