Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!!
I have this formula in QlikSense (Bar Chart) :
Num(sum({<Mes{'$(=DATE(FLOOR(MonthStart(AddMonths(max(Fecha),-1))),'MMM'))'}>}FieldName),'#.##0')
Works Fine! When I select 2020 May Shows Apr, 2020 Apr Shows Mar and so on,
But When I Do Clic in 2020 January QlikSense Shows Me 0 (In December 2019)...
What could be?
Thanks!!
Try this may be
Num(Sum({<Period = {"$(=Date(MonthStart(Max(Fecha), -1), 'MMM-YYYY'))"}, Year, Mes, Fecha>} FieldName), '#.##0')
Do you have a field which shows Month and Year like MonthStart or MonthYear?
Hello,
Yes I have I field called: Period -> ene-2020, feb-2020, mar-2020.
And So on...
Try this may be
Num(Sum({<Period = {"$(=Date(MonthStart(Max(Fecha), -1), 'MMM-YYYY'))"}, Year, Mes, Fecha>} FieldName), '#.##0')
Great!!