topic Re: Pivot Table Substraction in QlikView

Pivot Table Substraction

Wed, 25 Nov 2020 16:16:04 GMT

Please find the attached .QVW file.

Query1:-

I want to remove extra space from Market Value and Demo Value (Pivot Tables) , how can I remove that ?

Query2:-

I want to subtract Market Value (300) from Demo Value(1700) i.e. 1700-300=1400 and should display this subtraction below Total as

Net Assets** ("Demo Value-Market Value")=1400

Please help.

Re: Pivot Table Substraction

priyasawant — Mon, 20 Feb 2017 11:18:44 GMT

You can directly write it in the backend

Load *,

Demo Value-Market Value as Net Assets;

Re: Pivot Table Substraction

Anil_Babu_Samineni — Mon, 20 Feb 2017 11:32:08 GMT

First One this?

Second one where you want to see those?

Re: Pivot Table Substraction

Mon, 20 Feb 2017 11:38:33 GMT

I want to display subtraction(1400-300) below Total value.

Re: Pivot Table Substraction

Anil_Babu_Samineni — Mon, 20 Feb 2017 11:41:29 GMT

That's fine where you want to show this? KPI ??

If KPI

=Sum({<Level1 -= {'Cash'}>} [Market Value]) - Sum({<Level1 = {'Cash'}>} [Market Value])

Re: Pivot Table Substraction

surendraj — Mon, 20 Feb 2017 11:42:00 GMT

Please Find the attached one.

May be this help you!!

Re: Pivot Table Substraction

Mon, 20 Feb 2017 11:57:08 GMT

Need to display like below.

Re: Pivot Table Substraction

Anil_Babu_Samineni — Mon, 20 Feb 2017 12:25:45 GMT

Do you like this Approach

Re: Pivot Table Substraction

Mon, 20 Feb 2017 15:45:18 GMT

Thanks Anil for the reply. I am looking for 2nd option which you shown above and m looking for the same.

Please explain below which you wrote in expression.

Sum({<Level1 -= {'Cash'}>}[Market Value])-Sum({<Level1 = {'Cash'}>}[Market Value])

Re: Pivot Table Substraction

Anil_Babu_Samineni — Mon, 20 Feb 2017 15:54:25 GMT

Sum the [Market Value] where Level1 is not the Cash(Means Remaining) Minus Sum the [Market Value] Where Level1 is Cash(Only Cash)

In fact, I would love to go first option instead of Second one due to moving issue if AJAX Client

I assume, You are happy with that. I would request you to close this thread by marking Help full and Correct Answer so that next lander may understand at a moment

Re: Pivot Table Substraction

Tue, 21 Feb 2017 08:36:51 GMT

Thanks Anil for your help , It solved my problem.