Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

s_santalucia
Contributor

Subtraction between two measures

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!

1 Solution

Accepted Solutions
c_pannese
New Contributor III

Re: Subtraction between two measures

hi Stefania,

try this

Pivot table total as measurement

11 Replies
YoussefBelloum
Esteemed Contributor

Re: Subtraction between two measures

Hi,

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

vinieme12
Esteemed Contributor II

Re: Subtraction between two measures

s_santalucia
Contributor

Re: Subtraction between two measures

Hi Youssef Belloum,

                       XX                                     p                                                       s

Image 2.png

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
Contributor

Re: Subtraction between two measures

Hi Vineeth

I published it in response to Youssef Belloum

vinieme12
Esteemed Contributor II

Re: Subtraction between two measures

can you also post the expected output?

in excel maybe!

YoussefBelloum
Esteemed Contributor

Re: Subtraction between two measures

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
Contributor

Re: Subtraction between two measures

Hi Vineeth,

here it is.

s_santalucia
Contributor

Re: Subtraction between two measures

Hi,

I have posted the file excel.

look that.

c_pannese
New Contributor III

Re: Subtraction between two measures

hi Stefania,

try this

Pivot table total as measurement

Community Browser