Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Solution suggested by Sokkorn is perfect and it should definitely work.
It does, Thanks
Thanks