Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?