Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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

Highlighted

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...

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