# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Highlighted
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

Tags (4)
6 Replies
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.

New Contributor II

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

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

## 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)

New Contributor II

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

Tried that but did not work

Partner

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

Can you send me the qvf?