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: 
Not applicable

how to variable name to Diffrence

Hi Friends,

I crated Pviot table with values Sum(A) adn Sum(B). I want to take diffrence between these two values.

I created a varibale vDiff=Sum(A)-Sum(B). Its giving me a total aggregation difference.

.

Please let me know how to only difference between Sum(A) and Sum(B) specific to that row only.

Thanks

12 Replies
jyothish8807
Master II
Master II

You can get the different simply by creating a third exp"

Sum(A)-aum(B).

There is no need to create a variable for that.

If you try to crate a variable then it will not get asociated with the staright chat you will use.

You can try by calling the variable in a text box,it will give the right output according to your selection but will gice the grand total difference in a staright chard.

Regards

KC

Best Regards,
KC
Not applicable
Author

Thanks Jyothish

MY problem is if the user clicks on diffirence value another piovt chart shoud appear with current selections.

For that I want to create a variable for the diffrence. Based on the variable I will give conditional show to second pivot chat. Is there any other way??/?

jyothish8807
Master II
Master II

Hi,

PFA. In variable write:(Don't put = sign)

Var

col2-col1


*corresponding field in your case

In straight chart call:

$(Var)

You will get what you want.

Regards

KC

Best Regards,
KC