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: 
Anonymous
Not applicable

How to compare different time periods in one table

I'm having trouble coming up with a method to do something like this:

TypeSales
1Sum(Sales) where Sale Date is in a range dependant on dimension value (Fields StartDate and EndDate)
2
Sum(Sales) where Sale Date is in a range dependant on dimension value (Fields StartDate and EndDate)

Where each Type has a StartDate and EndDate.

for example for Type = 1, Sales between StartDate = 10/1/2015 and EndDate = 10/31/2015

and for             Type = 2, Sales between StartDate = 10/15/2015 and EndDate = 11/5/2015

The number of distinct Types is dynamic. I've never used alternate states but could that be used for this?

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Add StartDate and EndDate as dimensions and use Sum(Sales) as expression.


talk is cheap, supply exceeds demand