Sales Comparisons based on date ranges, yearly 3 months etc

[#1]

Hi All,

Need some help please, I know its pretty straight forward however I'm still learning the date functions in qlikview.

I basically need the table below replicated in qlikview.

Dimension	Total Sales Last 12 Months	Total Sales Previous 3 Months	Total Sales Current Month

Thank you

[Sokkorn · Accepted solution]

Hi jajram944,

Here is just an idea to implement in QlikView:

1. Total Sales Current Month

= Sum({$<MonthID = {$(=Max(MonthID))},Year = {$(=Max(Year))},Quarter = , Month = >} Sales)

2. Total Sales Previous 3 Months

= Sum({$<MonthID = {$(=Max(MonthID)-3)},Year = ,Quarter = , Month = >} Sales)

3. Total Sales Last 12 Months

= Sum({$<MonthID = {$(=Max(MonthID)-12)},Year = ,Quarter = , Month = >} Sales)

It would be greate if you can share sample data.

Regards,

Sokkorn

[#3]

Thanks for your help,

Unfortunately I'm unable to share my data.

Is it possible you can explain or break down the expression so I know what to replace each section with to match my data?

Thanks

[suniljain]

Solution suggested by Sokkorn is perfect and it should definitely work.

[#5]

It does, Thanks

[#6]

Thanks