dynamic dimension in a set analysis

Tue, 22 Oct 2013 11:37:00 GMT

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

topic dynamic dimension in a set analysis in QlikView

dynamic dimension in a set analysis