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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
griffin2571
Contributor
Contributor

Invalid Dimension when I use Set Analysis to a dimension to Table

I used this script when I added the dimension =Only({<[Condition of Car]={'Faulty'}>} [Status]) and the expression editor keeps showing it is okay. However, once I click okay I get an invalid dimension. When I used the alternative solution =Aggr(Only({<[Condition of Car]={'Faulty'}>} Status), Status) then I get duplicates in my data that I don't want. 

 

Is there a reason the first script will keep throwing back an invalid dimension? 

griffin2571_0-1670865472339.png

griffin2571_0-1670865598412.png

 

griffin2571_2-1670865496242.png

Status Corporate Dealer Location Condition of Car
Repair Shop Diamler Qatar Faulty
Repair Shop BMW Qatar Good
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Good
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar Faulty
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar OBCD
Repair Shop Diamler Qatar Orange
Repair Shop Diamler Qatar Faulty
1 Reply
hic
Former Employee
Former Employee

The expression
=Only({<[Condition of Car]={'Faulty'}>} [Status])
is a valid measure, but not a valid dimension.

Unfortunaltely, the expression editor thinks the syntax is OK, when it in fact isn't.

The expression
=Aggr(Only({<[Condition of Car]={'Faulty'}>} Status), Status)
is a a valid dimension.

Where do you get duplicates?