Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
]
;