Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How would you fix this expression?

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.

=if([Dimension 1]='Campaign', Campaign,

if([Dimension 1]='Date', Date,

if([Dimension 1]='Department Name', [Department Name],

if([Dimension 1]='Domain', Domain,

if([Dimension 1]='Market', Market,

if([Dimension 1]='Weekday', WeekDay, Null()

))))))

1 Reply
swuehl
MVP
MVP

Maybe like

=$(=only([Dimension 1]))