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: 
Manu25
Contributor
Contributor

Set Analysis , Date not showing on X axis , How to include 0 values in Vizlib chart

Hello 

so i have to show values of sales for the past 30 days , including the days which have 0 value for sales 

Usually in qlik sense chart , i can do it with a toggle button of show null values /show missing values

But i am using a Vizlib chart which doesnt have that option , so the only way to correct it is with expression 

I saw that Sum({1}0) works 

But it doesnt work in my case ., because i use a count statement , could someone help me solve this ...

Basically, How to  use a set analysis statement to show 0 values for dates and show all 30 dates

Labels (3)
1 Reply
KGalloway
Creator II
Creator II

What does your data look like? When I use the data below in a vizlib chart, I see the 0 sales days in the chart (picture below).

load * inline [
date, sales
1/1/2023, 0
1/2/2023, 10
1/3/2023, 0
1/4/2023, 20
1/5/2023, 20
1/6/2023, 0
1/7/2023, 10
1/8/2023, 10
1/9/2023, 20
1/10/2023, 20
]
;

KGalloway_0-1675459467751.png