Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Dates are missing in pivot while selecting filters

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

10 Replies
Highlighted

May be try something like this

Expression + Avg({<Site>} 0)

Highlighted
Creator II
Creator II

No luck Sunny,

Thank you  for respond

Highlighted
Contributor III
Contributor III

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.

Highlighted

A sample might help here

Highlighted
MVP & Luminary
MVP & Luminary

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

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Rob,

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

Highlighted
Creator II
Creator II

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

Highlighted

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

Highlighted
MVP & Luminary
MVP & Luminary

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