Subtraction between two measures

[s_santalucia]

Hi all,

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!

Thanks!

[YoussefBelloum]

Hi,

what do you mean by "only S must be subdivided by another dimension." ?

[vinieme12]

can you post a sample ?

How to get answers to your post?

Qlik Community Tip: Posting Successful Discussion Threads

[s_santalucia]

Hi Youssef Belloum,

                       XX                                     p                                                       s

S must be subdivided by the subgroup of the dimension, but P must not be subjected to this, it must always be the total subdivided by the main dimension and then P-S.

Thanks

[s_santalucia]

Hi Vineeth

I published it in response to Youssef Belloum

[vinieme12]

can you also post the expected output?

in excel maybe!

[YoussefBelloum]

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 ?

[s_santalucia]

Hi Vineeth,

here it is.

[s_santalucia]

Hi,

I have posted the file excel.

look that.

[c_pannese · Accepted solution]

hi Stefania,

try this

Pivot table total as measurement