PIVOT TABLE ISSUE

Sat, 30 Jan 2016 17:13:38 GMT

I have a pivot table with State as a dimension . If you see the attachment NO_Month_Selection. I can see Sates 'AR' and 'KY' which is what I would like to see, but as soon as I select the month 'Jan' (attachment MOnth_Selection), I loose 'AR' and 'KY'. What do I need to do so that I should see 'AR' and 'KY'.

Here is my expression

If((sum({<Year={$(=MAx(Year))},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD)

sum({<Year={$(=MAx(Year)-1)},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=>}INDEMNITY_PAID_YTD-INDEMNITY_RECOVERY_YTD))='0',0,

((max({<Year={$(=Max(Year))} ,NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=,Month = {"<=$(=Max(Month))"}>}MthNbr)/12)

*Sum({<Year={$(=Max(Year))},NO_BOP_FLAG={'0'},ORGANIZATION_NAME= ,[Line of Business]=,Month = {"<=$(=Max(Month))"}>} ind_budget)))

Re: PIVOT TABLE ISSUE

swuehl — Sat, 30 Jan 2016 21:49:59 GMT

Have you intended to attach some files to your post?

If possible, please attach also a small sample QVW that demonstrates your issue?

topic Re: PIVOT TABLE ISSUE in QlikView

PIVOT TABLE ISSUE

Re: PIVOT TABLE ISSUE