topic Re: Pivot table in QlikView

Pivot table

upaliwije — Thu, 06 Jun 2019 09:23:05 GMT

Hi Friends,

I have pivot table in my attached QV doc.

My Provision B/F Column (1)represent to total of PROV_Amount less than PR_YM period and as shown above result is ok. But when I make selection in PD _MY figures in 1st column disappear as shown below

Kindly look into my attached Qv doc and help to correct the issue please.

Re: Pivot table

tresB — Thu, 06 Jun 2019 10:30:32 GMT

For PD-YM 201905 calculated value is 0 even in the first case. I couldn't see any issue.

Re: Pivot table

upaliwije — Thu, 06 Jun 2019 10:41:10 GMT

Thanks

Why then Provision B/F is 0 in second case please ?

Re: Pivot table

sunny_talwar — Thu, 06 Jun 2019 11:32:32 GMT

What exactly are you hoping to see when you select 201905 in PD_YM? I mean do you want to ignore selection of PD_YM for your PROVISION B/F expression?

Re: Pivot table

upaliwije — Thu, 06 Jun 2019 11:39:04 GMT

Yes Sunny

That is exactly what I want

Re: Pivot table

sunny_talwar — Thu, 06 Jun 2019 11:40:25 GMT

Then ignore selection in PD_YM

Sum({<PR_YM = {"<$(=MAX(PR_YM))"}, PD_YM>} PROV_AMOUNT)