Some data is not displaying in Pivot table

[Rajesh]

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

[ogautier62]

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)

[ogautier62]

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

instead of day as measure,

calculate day with week and weekday

[Rajesh]

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

[sunny_talwar]

Is this not what you expect

[Rajesh]

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

Can you try it reload and check.

[sunny_talwar]

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

[Rajesh]

Yes my bad

is there any other way get it display Sunny

[sunny_talwar]

may be look into Generating Missing Data In QlikView