topic Column difference in Pivot table/Staright table in QlikView

Column difference in Pivot table/Staright table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the data as per attached excel sheet (data.xls).

I want to get the difference between last two columns in Pivot table / Straight table.

Source	Team	BDate	2018-03-01	2018-03-08	2018-03-15	Diff (between last tow columns)
Client1	Team1		510	1010	1510	500
Client1	Team2		60	110	160	50
Client2	Team1		5100	10100	15100	5000
Client2	Team2		600	1100	1600	500

fabdulazeez — Thu, 22 Mar 2018 02:50:37 GMT

In a straight table you can do Column(3) - Column(2)

shiveshsingh — Thu, 22 Mar 2018 06:12:19 GMT

Try column(3)-Column(2)

Can you share your app?

Anonymous — Thu, 22 Mar 2018 09:16:37 GMT

Hi,

Try Column(3) - Column(2) . If this was not works in your case, share the sample application.

Thanks,

Venkata Sreekanth

Anonymous — Fri, 23 Mar 2018 02:34:28 GMT

Thanks for your reply,

I have attached the data I am using.

I have data vertically and the data will change (means data is not static).

In pivot I can move the dimension from vertical to horizontal.

But how can I achieve desired result in straight table. Can you please create the sample application with the data I have attached.