Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
aelturk123
New Contributor II

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

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

6 Replies
thi_pham
Contributor

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

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

aelturk123
New Contributor II

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

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

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

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

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)

aelturk123
New Contributor II

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

Tried that but did not work

Partner
Partner

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

Can you send me the qvf?