topic Re: how to variable name to Diffrence in QlikView

how to variable name to Diffrence

Mon, 29 Sep 2014 10:06:43 GMT

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

Re: how to variable name to Diffrence

manideep78 — Mon, 29 Sep 2014 10:09:12 GMT

Take A and B as Dimensions.

Now add an expression RangeSum(A)-RangeSum(B)

Hope this helps.

Regards,
Manideep

Re: how to variable name to Diffrence

Mon, 29 Sep 2014 10:10:36 GMT

Hi,

Add one more expression in pivot table with Expression label1-Expression label 2.

which will be nothing but Sum(A) -Sum(B) specific to that row only.

Re: how to variable name to Diffrence

senpradip007 — Mon, 29 Sep 2014 10:11:17 GMT

Give names for Sum(A) and Sum(B), for example let say you give Sum(A) as colA and colB for Sum(B). Now you can write colA - colB and you will get your desire result.

Re: how to variable name to Diffrence

Mon, 29 Sep 2014 10:11:31 GMT

RangeSum will work.

Please see if that helps.

Thanks!

Re: how to variable name to Diffrence

ashfaq_haseeb — Mon, 29 Sep 2014 10:11:46 GMT

Hi.

write third expression as

Sum(A)-Sum(B)

Column(1)-column(2)

Regards

ASHFAQ

Re: how to variable name to Diffrence

anbu1984 — Mon, 29 Sep 2014 10:22:35 GMT

You can use labels assigned to Sum(A) and Sum(B). Check this

Re: how to variable name to Diffrence

Mon, 29 Sep 2014 10:27:41 GMT

Please send the code I am working on Personal Edition

Re: how to variable name to Diffrence

Mon, 29 Sep 2014 10:28:35 GMT

Thanks Freinds

But I want to assign a varibale to Sum(A)-Sum(B).

Thanks

Pavan

Re: how to variable name to Diffrence

anbu1984 — Mon, 29 Sep 2014 10:34:53 GMT

Do you want to store difference for any particular row in the variable? What is the condition to select that row?

Re: how to variable name to Diffrence

jyothish8807 — Mon, 29 Sep 2014 10:40:00 GMT

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

Re: how to variable name to Diffrence

Mon, 29 Sep 2014 10:51:37 GMT

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??/?

Re: Re: how to variable name to Diffrence

jyothish8807 — Mon, 29 Sep 2014 17:07:09 GMT

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