topic How would you fix this expression? in QlikView https://community.qlik.com/t5/QlikView/How-would-you-fix-this-expression/m-p/496994#M1147653 <HTML><HEAD></HEAD><BODY><P>The expression is for a dimension. There is a list box which the user selects his desired Dimension. I didn't know else to get the dimension to change according to this list box. </P><P></P><P>=if([Dimension 1]='Campaign', Campaign,</P><P> if([Dimension 1]='Date', Date,</P><P> if([Dimension 1]='Department Name', [Department Name],</P><P> if([Dimension 1]='Domain', Domain, </P><P> if([Dimension 1]='Market', Market,</P><P> if([Dimension 1]='Weekday', WeekDay, Null()</P><P> ))))))</P></BODY></HTML> Thu, 15 Aug 2013 12:27:52 GMT 2013-08-15T12:27:52Z How would you fix this expression? https://community.qlik.com/t5/QlikView/How-would-you-fix-this-expression/m-p/496994#M1147653 <HTML><HEAD></HEAD><BODY><P>The expression is for a dimension. There is a list box which the user selects his desired Dimension. I didn't know else to get the dimension to change according to this list box. </P><P></P><P>=if([Dimension 1]='Campaign', Campaign,</P><P> if([Dimension 1]='Date', Date,</P><P> if([Dimension 1]='Department Name', [Department Name],</P><P> if([Dimension 1]='Domain', Domain, </P><P> if([Dimension 1]='Market', Market,</P><P> if([Dimension 1]='Weekday', WeekDay, Null()</P><P> ))))))</P></BODY></HTML> Thu, 15 Aug 2013 12:27:52 GMT https://community.qlik.com/t5/QlikView/How-would-you-fix-this-expression/m-p/496994#M1147653 2013-08-15T12:27:52Z Re: How would you fix this expression? https://community.qlik.com/t5/QlikView/How-would-you-fix-this-expression/m-p/496995#M1147654 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=$(=only([Dimension 1]))</P></BODY></HTML> Thu, 15 Aug 2013 12:35:25 GMT https://community.qlik.com/t5/QlikView/How-would-you-fix-this-expression/m-p/496995#M1147654 swuehl 2013-08-15T12:35:25Z