How can I show all aging label in my chart although the value is null? As you can see in my chart below, the label for 15-21 days was not displayed.
Another question is how can I define the expression of new cases as 'yes or 'no' in my table? Let say, the ticket was created on current month and year, then it's define as a new case which is 'Yes'. Otherwise, it will be 'No'.
|Case by Aging||No of Cases|
|> 3 months||5|
If you'll have good example for aging, please share with me as I'm still a newbie for qlikview.
Best I can offer are the following Design Blog posts that may be helpful:
If you want to search further on your own there, use the following link:
Hopefully those may give you some further ideas to pursue things.
Hi @Lily ,
To answer your first question, the reason why data is not displaying for 15_21 days even if it has 0 value is because of the Suppress null value option in Object properties.
To disable it, and to show all the values from your dimension, go to Object Properties by right-clicking it.
Then, check for 'Suppress When Value is Null' in Dimension tab if it's checked. Then, Uncheck it.
Or, go to the Presentation tab, and in the bottom side, You'll again find 'Suppress Zero-Values', and uncheck it.
After pressing Ok, you will see all the dimension values in your chart.
To answer your second question, use this expression in your Edit Script.
if(MonthStart(today())<=Created_Date, 'Yes', 'No') as New_Case
I hope these solutions might help you with your knowledge of Qlikview.
I have tried your solution, but it's same, the bucket 15-21 days not appear in chart.
And for 2nd question, it's work fine.
Btw, thank you for your help.
Hi @Lily ,
Glad to help!
I believe for the first question, once check with data as well, if it's in proper integer type. And then try to create this table in other types of charts.
For example, if your main visualization type is the Bar chart, then start with simple table visual and try to debug the case step by step. The issue must be with suppressing zero values only. I will post again if I get any alternate solution.