Missing Data in Data Table

[#1]

Hi

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

[sunny_talwar · Accepted solution]

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)

[#3]

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

Hope this helps!

[#4]

Would you mind attaching a sample of the qvw?

[stabben23]

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

[stabben23]

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

[Anonymous]

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

[#8]

Hi

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

[sunny_talwar]

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