Dates are missing in pivot while selecting filters

[Anonymous]

Hi All,

Having data available from 01/01/2016 to 8/30/2017 , in this for some sites containing all dates, but some not

usually in the pivot all dates are coming , until if we select any site   (Dates are missing which are not associate or no data )

can we get all dates even after selection happen on site ?

also i enable show all values and disable suppress zero values as well

Please help on this ?

Regards,

Dev

[sunny_talwar]

May be try something like this

Expression + Avg({<Site>} 0)

[Anonymous]

No luck Sunny,

Thank you  for respond

[sam_grounds]

If you display your detail in a line/bar chart rather than a pivot, you can enable "Continuous" mode on the axis in question, which will automatically fill in any steps in your dimension between the min and max. I don't believe QlikView's default behaviour will allow you to show disassociated values in pivot tables.

Sorry to be the bearer of bad news.

[sunny_talwar]

A sample might help here

[rwunderlich]

I think Sunny got it right, just forgot the "=".

Expression + Avg({<Site=>} 0)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[sunny_talwar]

Rob,

It might be a bug, but ignoring selection in a field works without an equal sign also.

[Anonymous]

After you clear site code we will get all dates , try to select site code and see

[sunny_talwar]

I think this can only be resolved by populating the missing value...

[rwunderlich]

Sunny, you are correct. I overlooked that as I always code the =.

I wonder why it didn't work for the OP? Maybe other selections that need to be ignored as well?

-Rob