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?
mto, Can you help me in this?
Can you attach sample QVF file to test
What is the format of your field Month?
Hey,
There is restriction to copy files from server to local. So, can not attach the file
Hey,
The follwoing expression is working fine:
Sum({< Year = {'$(vCurYear)'}, Month = {'$(vCurMonth)'}, [Transaction Type] = {'Sales'}>}Amount)/10000000
But when i tried to execute with following expression, it is not working fine:
Sum({< Year = {'$(vCurYear)'}, Month = {'<=$(vCurMonth)'}, [Transaction Type] = {'Sales'}>}Amount)/10000000
As I said, you could use double quotes for variable. Aren't you?
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
see if the month is numerica; or create a numeric field : num(..)
and put it into " " not single quotes
Thanks, it helps. Can you help em in this?