topic Re: Missing Data in Data Table in QlikView

Missing Data in Data Table

Tue, 13 Sep 2016 14:26:59 GMT

I have a chart and a data table of the chart.

The chart shows zero values where there is no data to display

When I click on the data table, the data table doesn't show all the data and misses out months where there is no data.

Can anyone guide me with this as to why there is no data displaying in the data table, but can be seen in the chart?

Thanks

Re: Missing Data in Data Table

sunny_talwar — Tue, 13 Sep 2016 16:00:07 GMT

Have you already tried unchecking Suppress Zero Values on the presentation tab?

Also try adding this at the end of your expression

YourExpression + Avg({1} 0)

Re: Missing Data in Data Table

Tue, 13 Sep 2016 21:27:13 GMT

Under Chart Table properties --> Dimensions --> Uncheck "Suppress When Value Is Null" if checked

Hope this helps!

Re: Missing Data in Data Table

Wed, 14 Sep 2016 02:22:54 GMT

Would you mind attaching a sample of the qvw?

Re: Missing Data in Data Table

stabben23 — Wed, 14 Sep 2016 08:17:36 GMT

Hi,

you should build a dataisland where you keep all month regardless on what selection you made.

You will find some info here http://blog.axc.net/showing-missing-time-data

Re: Missing Data in Data Table

stabben23 — Wed, 14 Sep 2016 08:41:34 GMT

Combine also With this, check "Show all values".

Re: Missing Data in Data Table

Anonymous — Wed, 14 Sep 2016 10:12:07 GMT

go to chart properties, dimensions and then check on "Show all values" it will solve the issue

Re: Missing Data in Data Table

Wed, 14 Sep 2016 10:24:29 GMT

Thank you. This has resolved the issue and the missing data now appears.

what I am not clear about is how this issue was corrected by adding + Avg({1} 0) at the end.

What is this doing to my expression? Are you able to help me understand?

Will this change the data returned?

Thanks

Re: Missing Data in Data Table

sunny_talwar — Thu, 15 Sep 2016 00:37:45 GMT

It is just a way to add 0 for places which become nulls when you have made selections. {1} made sure that even with a selection 0 still remains and doesn't turn into a null.

If you got what you wanted, I would suggest marking the correct and helpful response to close this thread.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny