Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ismqui00
Contributor III
Contributor III

Order Count - Date measure

Trying to create a measure that will be used in a table for a report.  Basically, Report will have individual dates as row with measures as columns and will be used in mornings to check information from day befoe.  The measure I am trying to get specifically would count distinct orders from the day before. 

So far the expression I have is:

count(DISTINCT{$<[completed_date.autoCalendar.Date]={"$(=Date(max([completed_date])-1))"}>}([order_id]))


This only shows yesterdays (9/13) order total but, I am trying to get something like:


Date          Value

9/14/2018  (Order Count from 9/13/2018)

9/13/2018  (Order Count from 9/12/2018)

9/12/2018  (Order Count from 9/11/2018)... so on


Any example of an expression that would do this?  I think my expression is close, just not what I need.  Thanks in advance.     

0 Replies