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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Include 0 value dates between min and max days - Continued

I have already posted about this, but since my last post, for some reason the solution has stopped working.  A link to my first post is here:

Include 0 value dates between min and max days

So the problem I am having is that I want to show on my bar chart all days/year-months that have zero open sales orders so as to have a good visual timeline of when these orders will go out.  So the final expression that was derived from the first post is as follows:

sum ({$<SalesTransactionType = {'Open Order'}>}SalesTopLine)

+

sum ({$<OrderRequiredDateKey={">=$(=date(Min({<SalesTransactionType = {'Open Order'}>} OrderRequiredDateKey)))<=$(=date(Max({<SalesTransactionType = {'Open Order'}>} OrderRequiredDateKey)))"}>}0)



This works perfectly when I have not made any selections (see picture below with zero $ months):

good.jpg

But when I make a selection, it all goes away (see picture below, not zero $ months are showing):

bad.jpg

Am I missing something? 

Thanks again. 

0 Replies