Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum a backward

Problen with sum

In the first column I would like to have sum with sum date 2017-05-01and in the other column sum date 2016-05-01

ex

how big was sales, last year at a specific date

//Janne

3 Replies
Anil_Babu_Samineni

May be this?

Sum({<DateField = {'$(=AddYears(Max(DateField),-1))'}>} Sales)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

What is your chart dimension here?

Anonymous
Not applicable
Author

I have tried that variant but it will only be 0

//=Sum({<Date = {'$(=AddYears(Max(Date),-1))'}>} sales)

21767454,82->2016-05-01

3201530,09 ->2017-05-01