Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am stuck in one issue in QLIKSENSE.
I have created a variable vCurMonth = "=Month(Today())"
I am calculating Sum(Amount) as:
Sum({<Year = {'$(vCurYear)'},Month = {'<=$(vCurMonth)'},[Transaction Type] = {'Sales'}>}Amount)
Above expression is not working because of following clause:
Month = {'<=$(vCurMonth)'}
Can anyone help me in this?
Hi Nikhil,
If you take filter for Month, is it showing up MonthNames like Jan, Feb... or 1,2,3.
If they are showing up names then it might be the reason why <= condition is not working, create MonthNum columns
so they hold and in variable also used =Num(Month(Today()))
Hope this helps
hi try like this
Month = {'<=$(=vCurMonth)'}
and for year its working ?
Month = {'<=$(=vCurMonth)'}
Hey,
With year it is working fine. I tries your way also in KPI oblject but it is not working fine for Month variable. Pls find attached snapshot
Hey,
With year it is working fine but with month as suggested by you, it is not working fine. Pls find attached snapshot
Is it possible to attach your qvf?
May be with Double Quotes?
Sum({<Year = {'$(vCurYear)'},Month = {"<=$(vCurMonth)"},[Transaction Type] = {'Sales'}>}Amount)
Hey,
There is restriction to copy from server to any other location so unfortunately cannot paste qvf. IF you could still help, would be great
Tried this but didnt worked.
Is month a number? Maybe you need the Date and Date# function to make this work