Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jaweher89
New Contributor III

create dynamic dimension

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))

];