topic Re: Dates are missing in pivot while selecting filters in QlikView

Dates are missing in pivot while selecting filters

Anonymous — Wed, 30 Aug 2017 13:40:02 GMT

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

Re: Dates are missing in pivot while selecting filters

sunny_talwar — Wed, 30 Aug 2017 13:57:59 GMT

May be try something like this

Expression + Avg({<Site>} 0)

Re: Dates are missing in pivot while selecting filters

Anonymous — Wed, 30 Aug 2017 14:10:17 GMT

No luck Sunny,

Thank you for respond

Re: Dates are missing in pivot while selecting filters

sam_grounds — Wed, 30 Aug 2017 14:22:10 GMT

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.

Re: Dates are missing in pivot while selecting filters

sunny_talwar — Wed, 30 Aug 2017 14:25:19 GMT

A sample might help here

Re: Dates are missing in pivot while selecting filters

rwunderlich — Wed, 30 Aug 2017 14:37:05 GMT

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

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Dates are missing in pivot while selecting filters

sunny_talwar — Wed, 30 Aug 2017 14:38:49 GMT

Rob,

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

Re: Dates are missing in pivot while selecting filters

Anonymous — Wed, 30 Aug 2017 15:33:05 GMT

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

Re: Dates are missing in pivot while selecting filters

sunny_talwar — Wed, 30 Aug 2017 15:46:51 GMT

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

Re: Dates are missing in pivot while selecting filters

rwunderlich — Wed, 30 Aug 2017 16:12:43 GMT

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

Re: Dates are missing in pivot while selecting filters

Anonymous — Thu, 31 Aug 2017 07:52:14 GMT

How we can resolve this one , the only problem is some of the codes are not associating with some dates , that's why when we select some site codes , some dates are missing