Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello friends of the Qlik community,
I want to calculate the sum of all the months before the month i a filter i created. I tried:
sum(YearMonth = {"<$(=vYearMonth)">} amount)
if i select year 2020 and month 5 in the filter i created, i will get all the results of the months under 05-2020 --> correct
now i want the results of the months before the month i selected but not lower then these months minus 3
So if i select month 05 -2020, i want only the months 4,3,2 of 2020
I tried sum( YearMonth = {"<$(=vYearMonth)"},JaarMaand = {">$(=vYearMonth-3)"}>} --> incorrect
vYearMonth = min(YearMonth) , which i created in the script. format is 202005
Can somebody help me where i go wrong?
Perhaps you looking for something like this
sum( YearMonth = {">$(=vYearMonth-3) <$(=vYearMonth)"}>}