pivot table in Qlik Sense

[Modiz]

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

[edwin · Accepted solution]

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: