create dynamic dimension

Anonymous — Sat, 05 Sep 2015 22:35:19 GMT

i have the following dimension

LOAD * INLINE [

Period,Column

Month,Actual Mth

Month,Budget Mth

YTD,Actual YTD

YTD,Budget YTD

YTD,Variance YTD

];

Is the a way to add year selection in the dimension

LOAD * INLINE [

Period,Column

Month,Actual Mth(max (year))

Month,Budget Mth(max (year))

YTD,Actual YTD(max (year))

YTD,Budget YTD(max (year))

YTD,Variance YTD(max (year))

];

topic create dynamic dimension in QlikView