Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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