Discussion board where members can get started with Qlik Sense.
I am facing an issue in Qlik Sense: the date where sum(value) equals 0 disappears from the axis.
Dimension: Dates from a MasterCalendar table
Measure: Sum of values (from the Facts table)
The below solutions were already attempted but did not work. What other solutions can I try?
- show null values (in data)
- show zero values (in add-ons)
- Check Mastercalendar table is linked to the fact table
- Check all Mastercalendar fields exist
- change the table to bar chart
You can change chart to View Data and check if there is any weird thing.
Can you please clarify?
My case is:
The date where sum(value) equal 0 disappears, when I make a selection.
The date is from a Master Calendar table.
If I release the selection, the date appears with zero value.
I want the date to show even with selection
May be irrespective of selections should ignore? But not make sense? Can you able to share sample QVF file to test
Here enabling 'include zeroed values' worked ...
Have you ever tried using a condition in the measure?
because if you have tried these steps may be something else ...
try to force the expression to if the result is '<= 0' or isnull (result) return 0
if (expression <= 0 or isnull (expression), 0, expression)
Tried that but did not work
Can you send me the qvf?