Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Under Chart Table properties --> Dimensions --> Uncheck "Suppress When Value Is Null" if checked
Hope this helps!
Would you mind attaching a sample of the qvw?
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
Combine also With this, check "Show all values".
go to chart properties, dimensions and then check on "Show all values" it will solve the issue
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
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