topic Re: Difference Between two columns in Pivort Table in QlikView

Difference Between two columns in Pivort Table

krishna20 — Mon, 19 Jan 2015 10:06:22 GMT

Hi Friends,

I need to find the difference between two columns in pivort table.

My requirement is like

Year 2014 2013 2014 -2013

Product

Payment Recovery Payment Recovery Payment Recovery

A 100 200 150 120 -20 80

B 200 50 100 100 100 -50

C 400 200 100 200 300 0

How can we achieve this year's column difference.Please any one can suggest me.

Regards

Krishna

Re: Difference Between two columns in Pivort Table

alexandros17 — Mon, 19 Jan 2015 10:07:49 GMT

Example:

Sum({$ <year={2014}> Payment}

Sum({$ <year={2013}> Payment}

let me know

Re: Difference Between two columns in Pivort Table

avinashelite — Mon, 19 Jan 2015 10:11:26 GMT

Hi Krishna,

Try as mention by Alessandro, if your still not getting please post your app

Re: Difference Between two columns in Pivort Table

francoiscave — Mon, 19 Jan 2015 10:15:19 GMT

Hi Krishna,

In your case, if you want a column with the label 2013-2014, you must create it as value in the Year dimension.

It will be better to calculate your values in the script.

Or change the design of your chart.

François

Re: Difference Between two columns in Pivort Table

PrashantSangle — Mon, 19 Jan 2015 10:21:51 GMT

Hi,

As per my under standing

If Year and Product are dimension.

and Payment and Recovery are expression then

calculating difference of two value of dimension in Pivot table was not possible.

Try alternate "Straight Table"

and Hardcode Year Field Expression.

Regards

Re: Difference Between two columns in Pivort Table

krishna20 — Mon, 19 Jan 2015 10:27:01 GMT

Hi,

All Values getting zeros.The third difference column is not coming separately.It's coming under 2014 and 2013.

Regards

Krishna

Re: Difference Between two columns in Pivort Table

krishna20 — Mon, 19 Jan 2015 10:28:26 GMT

I followed this post also but no luck.

http://community.qlik.com/message/392636#392636

Regards

Krishna

Re: Difference Between two columns in Pivort Table

avinashelite — Mon, 19 Jan 2015 10:33:23 GMT

Can you please post your app? will check

Re: Difference Between two columns in Pivort Table

krishna20 — Mon, 19 Jan 2015 10:38:37 GMT

Hi Avinash,

No possibilities to share the app.Connecting the Server through VPN.

Regards

Krishna

Re: Difference Between two columns in Pivort Table

krishna20 — Mon, 19 Jan 2015 13:33:09 GMT

Hi Alessandro,

I did as per you suggested in pivort table.Getting Extra columns in the result. I added an option partial sums ,then only getting correct result.I dont want the extra fields.How can i remove these fields.Please suggest me how can we achieve it.Please find the attached image,Red color represents unwanted fields ,Green Color represents wanted fields.

Regards

Krishna

Re: Difference Between two columns in Pivort Table

alexandros17 — Mon, 19 Jan 2015 13:36:15 GMT

Unfortunatly you cannot have a total value without partial values (this means you cannot hide the columns in red)

Re: Difference Between two columns in Pivort Table

francoiscave — Thu, 22 Jan 2015 13:05:23 GMT

Hi Krishna,

Have you find a solution ?

If your are satisfied by a response, please mark it as correct or helpful to close this tread.

If not, how can we help you?

Thanks,

François