Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s_santalucia
Partner - Creator
Partner - Creator

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
Partner - Creator
Partner - Creator

11 Replies
YoussefBelloum
Champion
Champion

Hi,

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

vinieme12
Champion III
Champion III

can you post a sample ?

How to get answers to your post?

Qlik Community Tip: Posting Successful Discussion Threads

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
s_santalucia
Partner - Creator
Partner - Creator
Author

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
Partner - Creator
Partner - Creator
Author

Hi Vineeth

I published it in response to Youssef Belloum

vinieme12
Champion III
Champion III

can you also post the expected output?

in excel maybe!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
YoussefBelloum
Champion
Champion

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
Partner - Creator
Partner - Creator
Author

Hi Vineeth,

here it is.

s_santalucia
Partner - Creator
Partner - Creator
Author

Hi,

I have posted the file excel.

look that.

c_pannese
Partner - Creator
Partner - Creator

hi Stefania,

try this

Pivot table total as measurement