Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i would llike to show in pivot table two indicators - quantity and amount, but i would like to put it in two columns where quantity shoud by present only as a sum and amount shoud be divided on days, like in this example . Do you know maybe how to do it in qlik sense?
quantity | amount | ||||
total | total | 2022-07-01 | 2022-07-02 | 2022-07-03 | |
a | 10 | 15 | 1 | 5 | 9 |
b | 20 | 9 | 2 | 6 | 1 |
c | 30 | 12 | 3 | 7 | 2 |
d | 40 | 15 | 4 | 8 | 3 |
i edited my response as i forgot one option for appearance.
there will be 2 challenges if you want to use a pivot, you cant have 2 dimensions on the same row
measures cant be on the row side it will be on the pivot side. this means if you have 2 measures, each date will have 2 columns under it - your 2 measures.
fortunately, you can convert a measure into a calculated dimension (quantity):
agg(count(FIELDTOCOUNT), FIELDTOCOUNT)
that takes care of the 2nd challenge:
for the first challenge change this option:
i edited my response as i forgot one option for appearance.
there will be 2 challenges if you want to use a pivot, you cant have 2 dimensions on the same row
measures cant be on the row side it will be on the pivot side. this means if you have 2 measures, each date will have 2 columns under it - your 2 measures.
fortunately, you can convert a measure into a calculated dimension (quantity):
agg(count(FIELDTOCOUNT), FIELDTOCOUNT)
that takes care of the 2nd challenge:
for the first challenge change this option: