Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bimala0507
Partner - Creator
Partner - Creator

Enable to show all dimensions, with 0 value in expression

Hi Experts:

In one of  chart, I have Year and Month as Dimension and Count ( Sales Order Number)  as expression. I would like to show all Year and Months. Currently, if there is no Sales Order for a month, the month doesn't appear. I would like to have Month and value as 0. Tried possible ways of Showing All Values in Dimensions and Disable Suppress missing value in Presentation, but still not able to achieve. Basically I would like to have all Months and Year to be displayed with value 0 or actual value. Can anyone throw some idea on this?

Ex:

Year    Month  No. of Orders

2003    Jan     0

2003    Feb     10

2003    Mar      8

....

2003    Dec     3

Currently Month Jan is not appearing since, No. of Orders is 0

Kind Regards,

Bimala

2 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Go to chart properties Dimension tab --> Select your Dimension and check show all values.

Now go to presentation tab and deselect  suppress zero values.

Let me know if that worked.

Regards

ASHFAQ

sat_tok52
Creator
Creator

Hi ,

Use This Formula

=Num(Count ( Sales Order Number) +0.001),0.00)


you can able to see zero value on your chart.