Show date where sum(value) equals 0 - Master Calendar

[Anonymous]

Dear all

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

Thank you

Assaad

[thi_pham]

You can change chart to View Data and check if there is any weird thing.

[Anonymous]

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

[Anil_Babu_Samineni]

May be irrespective of selections should ignore? But not make sense? Can you able to share sample QVF file to test

[PabloTrevisan]

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)

[Anonymous]

Tried that but did not work

[PabloTrevisan]

Can you send me the qvf?