I have this question for you:
I have two measures: P and S and, for one dimension, I must get the subtraction (P-S) but only S must be subdivided by another dimension.
I hope for your help!
what do you mean by "only S must be subdivided by another dimension." ?
Hi Youssef Belloum,
XX p s
Sorry i can't follow..
what do you mean by "subdivided" ?
what is the subgroup of the dimension ?
maybe you don't want to take what is after the comma of the field S for some lines ?
I have posted the file excel.
can you post a sample ?
How to get answers to your post?
Qlik Community Tip: Posting Successful Discussion Threads
I published it in response to Youssef Belloum
can you also post the expected output?
in excel maybe!
here it is.
the table is clear ! just add the desired output on a new column
Pivot table total as measurement
Retrieving data ...