Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
upaliwije
Contributor II

Pivot table

Hi Friends,

 

I have pivot table in my attached QV doc. 

Screenshot_1.png

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

Screenshot_2.png

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

1 Solution

Accepted Solutions

Re: Pivot table

Then ignore selection in PD_YM

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

Re: Pivot table

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

Re: Pivot table

Thanks

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

 

Re: Pivot table

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?

upaliwije
Contributor II

Re: Pivot table

Yes Sunny

That is exactly what I want 

Re: Pivot table

Then ignore selection in PD_YM

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