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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count of days with sales in a selection

Hi Community,  When we do a sum(sales) expression graph with a dates dimension, is there anyway we can have a count for the number of days the

sum(sales) has a value?  Lets say the graph has a dimension of dates for a year.  Only 50 of those dates have any sales on them based on my current selection of item part.  Is there away to count this 50?

2 Replies
Not applicable
Author

try

Count(Distinct Total Date) for the total across the chart.

Not applicable
Author

Marcsliving, you got it but I have another issue.  I've got two expressions in the graph so the dimension of dates count gives a vlaue if the other expression has a value too.  How can I count the dates in the graph for only one of the expressions?