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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
griffin2571
Contributor
Contributor

Set Analysis expression throws error when having multiple parameters

I have this dataset that I am trying to get to create a set analysis where column "Car Model" is filtered on "Type of Repair" = Future and "Work Code" = WFH or FLT

The set expression I made was =only({<[Type of Repair]={'Future'} & {<[Work Code]={'WFH' or 'FLT'}[Car Model])

Car Vin Number Car Model Type of Repair Work Code Work Days Repair
9871637893 7 Series BMW Future WFH 5
9871637893 Toyota Carolla Processing FLT 5
9871637894 Honda Accord Planned FLT 19
9871637895 7 Series BMW Planned FLT 9
9871637896 Toyota Carolla Future FLT 5
9871637897 Honda Accord Future FLT 10
9871637898 7 Series BMW Future LTS 8
9871637899 Toyota Carolla Future WFH 3
9871637900 Honda Accord Future LTS 7
9871637901 7 Series BMW Future WFH 11
9871637902 Toyota Carolla Future WFH 7
9871637903 Honda Accord Future WFH 13
9871637904 7 Series BMW Future LTS 12

 

However, I keep getting an error message whenever I make this set expression and I am not sure why my set analysis won't work. Any idea what I am doing wrong?

Labels (5)
1 Solution

Accepted Solutions
Or
MVP
MVP

only({<[Type of Repair]={'Future'} , [Work Code]={'WFH','FLT'} >} [Car Model])

Your original syntax has multiple issues - using 'or', using '&', and not closing the tags >}, at the very least.

View solution in original post

1 Reply
Or
MVP
MVP

only({<[Type of Repair]={'Future'} , [Work Code]={'WFH','FLT'} >} [Car Model])

Your original syntax has multiple issues - using 'or', using '&', and not closing the tags >}, at the very least.