topic Re: Some data is not displaying in Pivot table in QlikView

Some data is not displaying in Pivot table

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

Hi All,

I have created Pivot table and converted it to CrossTable view with 2 dimensions and 2 measures

Dim1 : Week

Dime : WeekDay

Measure1: Day

Measure2 :

if(aggr(count(DISTINCT number), Week, WeekDay)>2,

aggr(count(DISTINCT number), Week, WeekDay)& ' Records'&chr(13)&chr(13)& concat(number & '- ' & short_description, chr(13)),

concat(number & '- ' & short_description, chr(13))

)

in this below pivot table missing some days as i marked one.

i would like to show the missing days

Can any one suggest the solution.

Thanks

Rajesh

Re: Some data is not displaying in Pivot table

sunny_talwar — Wed, 25 Jul 2018 11:29:20 GMT

Would you be able to share a sample to look at this?

Re: Some data is not displaying in Pivot table

Rajesh — Wed, 25 Jul 2018 11:37:38 GMT

Thanks for reply Sunny but have Confidential data.

Re: Some data is not displaying in Pivot table

sunny_talwar — Wed, 25 Jul 2018 11:40:28 GMT

Mocked up sample data or my be scrambling the data?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Some data is not displaying in Pivot table

ogautier62 — Wed, 25 Jul 2018 11:53:32 GMT

Hi,

for these days, is there any value ? (number and description)

I don't think so

regards

Re: Some data is not displaying in Pivot table

Rajesh — Wed, 25 Jul 2018 11:56:59 GMT

Hi Sunny,

Please find the attached qvw.

Re: Some data is not displaying in Pivot table

Rajesh — Wed, 25 Jul 2018 11:58:12 GMT

Hi Olivier

days are in numbers like 1 to 30

Re: Some data is not displaying in Pivot table

ogautier62 — Wed, 25 Jul 2018 12:02:44 GMT

yes but for these days, does exist value for other measure ?

Re: Some data is not displaying in Pivot table

sunny_talwar — Wed, 25 Jul 2018 12:09:03 GMT

But it seems to be working fine in the sample attached, right?

May be try with this expression for Day

Only({1} Day)

Re: Some data is not displaying in Pivot table

Rajesh — Wed, 25 Jul 2018 12:15:52 GMT

Yes some days don't have measures

Re: Some data is not displaying in Pivot table

ogautier62 — Wed, 25 Jul 2018 12:23:04 GMT

some or all days withh '-' ?

if some days has measure, maybe verify your calendar

either day is false

either same days has same dayweek (17 and 18 are on Tue for ex)

Re: Some data is not displaying in Pivot table

ogautier62 — Wed, 25 Jul 2018 12:34:03 GMT

if not displaying because no value (no number for this day)

instead of day as measure,

calculate day with week and weekday

Re: Some data is not displaying in Pivot table

Rajesh — Wed, 25 Jul 2018 12:37:37 GMT

No sunny not working in shared app also, select on DateType filter than it is not displaying

applied Only({1} Day) this also not working

Re: Some data is not displaying in Pivot table

sunny_talwar — Wed, 25 Jul 2018 12:39:55 GMT

Is this not what you expect

Re: Some data is not displaying in Pivot table

Rajesh — Wed, 25 Jul 2018 12:55:52 GMT

Sunny After reloading the app with ur expression its showing all null.

Can you try it reload and check.

Re: Some data is not displaying in Pivot table

sunny_talwar — Wed, 25 Jul 2018 12:57:47 GMT

You want me to reload your app without having the underlying data? How am I suppose to do that?

Re: Some data is not displaying in Pivot table

Rajesh — Wed, 25 Jul 2018 13:00:03 GMT

Yes my bad

is there any other way get it display Sunny

Re: Some data is not displaying in Pivot table

sunny_talwar — Wed, 25 Jul 2018 13:01:24 GMT

may be look into Generating Missing Data In QlikView