topic Re: Some raws are hidden in pivot table in QlikView

Some raws are hidden in pivot table

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

All,

While creating a pivot table to compare data with two period, some data of prod will be hidden. It seems to be locked by period data. The details are as the following steps:

1. Filter:

Current Period:2016/09

Last Period:2016/08

SITE_NM:COMPANY_C

Notice the red area, prod:F1V13000_E and prod:F1119000_E are show in 2016/09 and sub-total is -330,097.

2. Now changing the filter:

Current Period:2016/10

Last Period:2016/09

SITE_NM:COMPANY_C

Changing 2016/09 to last period, and notice prod:F1V13000_E and prod:F1119000_E. The data of prod:F1V13000_E and prod:F1119000_E in 2016/09 disappear. Actually, the data of prod:F1V13000_E and prod:F1119000_E is not exist in 2016/10, but they should be listed in 2016/09. Notice the sub-total of 2016/09, it is still-330,097.

3. Unchecking the Suppress zero-value

The data of prod:F1V13000_E and prod:F1119000_E in 2016/09 is null, and it seems to be locked by data of 2016/10. I've tried to clear the period field in expression, but the data is still null. Is there any way to show the data?

Re: Some raws are hidden in pivot table

sunny_talwar — Tue, 05 Dec 2017 13:43:42 GMT

Do you really need Pick Match here? May be this

Dimensions

PROD

Period

Expression

num(sum({<PROD={'F*'},YYYYn=,YYYY_HH=,YYYY_QQ=,YYYY_MM=,Date_ID={"$(=Max(Date_ID))", "$(=Max(Date_ID)-1)"}>}AMT),'#,##0')

Re: Some raws are hidden in pivot table

erichuang — Wed, 06 Dec 2017 01:04:18 GMT

Hi,

In my original case, I need to do other calculations in every period, such as the following picture(Curr%), and that's why I use 'Pick Match' to design the sheet. Are there other ways to resolve the issue?

Re: Some raws are hidden in pivot table

sunny_talwar — Wed, 06 Dec 2017 01:19:15 GMT

I think this is a data issue, I was unable to find the exact issue, but if you can share the expected output in an Excel file (for all dimensions), I might be able to help you achieve it

Re: Some raws are hidden in pivot table

erichuang — Wed, 06 Dec 2017 01:42:00 GMT

Hi,

Please reference the attachment and Thanks a lot.