Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.