Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use below formula in Qlik Sense which works fine in QlikView but not in Qlik Sense.
Sum({<Month_Num={"$(=Max(Month_Num)-1)"}>}[Sales Amount (Actual)])
It gives zero only. in Qlik Sense.
Any help will be appreciated.
Thanks,
Chetan
Have you checked that the field names match exactly? Month_Num is not MonthNum or Month_num? Because I don't see any reason for this expression to not work in Qlik Sense. May be share a sample for us to see?
Please post a small qlik sense app that shows this problem.
Quick work around is see first the below 2 expressions individually displaying values or not in a TextObkect/Image in QlikSense
=Max(Month_Num)-1
Sum([Sales Amount (Actual)])
Also get the list object for Sales AMount and MOnth_Num to see if values are present
Hi
Make sure that Month_num is numeric value
Load
Num(Month(Date) as Month_num
or use dual function
Then change your syntax
Sum({<Month_Num={"=Max(Month_Num)-1"}>} [Sales Amount (Actual)])
Hope this works
Please tag as correct or helpful if this works for you
Regards
Ziad
Thanks everyone for the help ...
I tried using below formula and it works fine now..but dont know why the previous formula was nor working.
=sum({$<Year={"$(=Max(Year))"},MonthID={"$(=Max(MonthID)-1)"},Month=>}[Sales Amount (Actual)])
Thanks,
Chetan