if condition in qliksense

[ksk278074]

Hi i am having data filed like 201101 upto 201201

now my agenda is load all months data dynamically

if(right('month',2)>12,$('vmonth')

what is the error in the above IF condition?

[agigliotti]

what does the variable vmonth contains ?

[ksk278074]

vmonth contains the data like 201701 to 201712

[agigliotti]

is vmonth a variable or field name ?

what are you trying to achieve with your IF condition ?

[YoussefBelloum]

Hi,

what did you call your field with quotes, try it like this:

if(right(month,2)>12,$(vmonth))