topic Re: Display Issue for months and quarter in QlikView

Display Issue for months and quarter

Wed, 25 Nov 2020 16:16:04 GMT

I have dataset that contains the data of names, date and values. while displaying in pivot table as shown below

Here values are displaying based on the data I have.

I also want to display missing months and quarters and years. Please help me how to fix it.

Thanks

Re: Display Issue for months and quarter

sunny_talwar — Thu, 07 Apr 2016 20:44:23 GMT

Have you tried unchecking 'Suppress when Null' on the Presentation tab?

Re: Display Issue for months and quarter

Thu, 07 Apr 2016 21:01:20 GMT

Yes I try..It fails.

My intention is show all months and quarters and Year even though there is no values on header.

Thanks

Re: Display Issue for months and quarter

sunny_talwar — Fri, 08 Apr 2016 00:36:07 GMT

Is it possible for you to share a sample?

Re: Display Issue for months and quarter

Fri, 08 Apr 2016 00:50:09 GMT

Hi Aditya

Try ticking the 'Show All Values' option for each dimension on the Dimensions tab of the pivot chart properties and make sure that 'Suppress When Null' is not ticked. Then on the Presentation tab untick the 'Suppress Zero Values' and 'Suppress Missing' options. If the 'Suppress Missing' option is greyed out then untick the 'Populate Missing Cells' option to activate it.

Hope that helps.

Kind regards

Steve

Re: Display Issue for months and quarter

ahammadshafi — Fri, 08 Apr 2016 09:19:00 GMT

Hi Aditya:

Does the data set have combinations you are trying to show with "blank" or "null" like the following?

Re: Display Issue for months and quarter

Fri, 08 Apr 2016 09:31:17 GMT

In presentation tab uncheck the supressing Missing values and supressing zero values and dimension also supress the null's

after that check your table it will show all the months and quarter as per the data mapped in your script.

Re: Display Issue for months and quarter

jonathandienst — Fri, 08 Apr 2016 09:38:13 GMT

It really depends on whether the expressions for the 'missing' months are nulls or missing. A null would be when the expression refers to data but the result is a null. A missing value is when there is simply no data in the model for that dimension value. For example, if your expression is summing something in the transaction table, and there is no entry in that table for March 2016, then the value would be missing, not null, even if all possible dates exist in the calendar.

Non-displayed null values can be resolved using the previous postings. Missing values can only be resolved by modifying your data set or modifying your query so that the dimension values are not missing. If you want specific help on how to do this, I suggest that you upload a sample qvw with some representative data.

Re: Display Issue for months and quarter

tresB — Fri, 08 Apr 2016 09:49:54 GMT

I guess, this could have been like:

even if all possible dates exist in the master calendar.

right?

Re: Display Issue for months and quarter

jonathandienst — Fri, 08 Apr 2016 09:54:07 GMT