Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sarbnyota001
Partner - Contributor
Partner - Contributor

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
lironbaram
Partner - Master III
Partner - Master III

make sure

that in your vMaxMonthYearName variable

the formula start with '=' sign

sarbnyota001
Partner - Contributor
Partner - Contributor
Author

YEs that has =, so its

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