Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamic dimension in a set analysis

Hi,

Wanted to know if it is possible to have a dynamic dimension in a set analysis. for eg

I have 2 expressions based on selection of a calendar year or financial year

for Calendar year my exp is

sum({<DATE_CYYYY=$(v_CDATE)>} Amount)

for Fiscal year my exp is.

sum({<DATE_FYYYY=$(v_CDATE)>} Amount)

I am setting a variable v_Year which can either have value as DATE_CYYYY or DATE_FYYYY.  I am setting this value on a click of a button. i.e when user clicks on Fiscal year then, v_Year is set to DATE_FYYYY and if he clicks on Calendar Year then value is DATE_CYYYY.

Now I have an expression as

sum({<$(v_Year)=$(v_CDATE)>}Amount OR

sum({<v_Year=$(v_CDATE)>}Amount

But it doesn't seem to work. Any help is appreciated.

Thanks

Lax

0 Replies