Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
tforse2000
Contributor
Contributor

Qlik Sense - Nested Variable Evaluation

Is there a method to dynamically evaluate nested variables?

I am trying to allow my users the ability to dynamically select a variable for current, previous and next quarter. The vQtrSelect has a drop down extension that lets the users dynamically select this variable. This variable would then be evaluated in vCurrentQtr.


The vCurrentQtr variable is evaluated within set analysis in the measures. The below is what I am trying to accomplish but it is failing to evaluate the vQtrSelect variable.

LET vQtrSelect = 2;

LET vCurrentQtr = '=IF(vQtrSelect=1,QuarterName(Today(0),-1),IF(vQtrSelect=2,QuarterName(Today(0)),QuarterName(Today(0)),+1))';

0 Replies