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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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