Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Partner
Partner

Nested variables in Qlik Sense

Hi,

I wonder if someone can help me.

I have two user input fields variable in the app. Year and Month. When user has entered this, the value is stored in variable of vYear and vMonth.

Then i want to take this "vYear" and "vMonth" and convert into year and month and Store value in a variable.

vMaxMonthYearName = MonthName(MakeDate($(vYear),$(vMonth)))

Then in the script I am calling the value of this variable by saying

LET vMonthYear = '$(vMaxMonthYearName)';

unfortunately this doesnt work. when i debug, i can see my vMonthYear returns me  = MonthName(MakeDate($(vYear),$(vMonth))) but i am expecting it to return the MonthYear value that the user has entered.

Can someone help out?

THanks

2 Replies
Partner
Partner

Re: Nested variables in Qlik Sense

make sure

that in your vMaxMonthYearName variable

the formula start with '=' sign

Partner
Partner

Re: Nested variables in Qlik Sense

YEs that has =, so its

=MonthName(MakeDate($(vYear),$(vMonth)))