Error in Expression

[nikhilgarg]

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?

[nikhilgarg]

mto‌, Can you help me in this?

[Anil_Babu_Samineni]

Can you attach sample QVF file to test

[OmarBenSalem]

What is the format of your field Month?

[nikhilgarg]

Hey,

There is restriction to copy files from server to local. So, can not attach the file

[nikhilgarg]

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

[Anil_Babu_Samineni]

As I said, you could use double quotes for variable. Aren't you?

[kkkumar82 · Accepted solution]

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

[OmarBenSalem]

see if the month is numerica; or create a numeric field : num(..)

and put it into " " not single quotes

[nikhilgarg]

Thanks, it helps. Can you help em in this?

Which browser to use on mobile for qliksense app