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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.