Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

listbox expression disabled for gray items

Is there any way to make the listbox to display the expression values for grayed out items. In the enclosed app, if a car is selected, all other cars show a '-' for car_name. I want to display the car_name for all list elements, regardless of their state.

1 Solution

Accepted Solutions
julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello Dennis

Try with this expression:

=Only({<car=>}car_name)

ReCaptura.JPG.jpggards

View solution in original post

7 Replies
julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello Dennis

Try with this expression:

=Only({<car=>}car_name)

ReCaptura.JPG.jpggards

ecolomer
Master II
Master II

Is this you need?

Not applicable
Author

This is strange. Your expression works fine in the attached qvw I uploaded; however, it doesn't do anything in my application.

Not applicable
Author

This works, but I would like the expression solution, since it "lines up" the fields ( I have three fields in my real application). BTW, where and how you defined the Expression appearing in the Field drop down?

Not applicable
Author

Figured it out. My bad.

Can you explain to me how does this expression work? what does {<car=>}, and Only() function mean and do here. . I know about set analysis and I read the Only() function description in Help, but still can not connect the dots.

thanks.

julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello Dennis,

The Only() aggregate function returns the unique value for the dimension value (on your case, the field "car").

The set analysis sentence {<car=>} indicates to Qlikview that ignore the selections made over the field "car".

So, as you can see, the final effect is that you can see the values for each expression, no matter which dimension value you have selected.

I use the Only funtion in order to apply the set analysis.

I hope to be clear, and sorry about my english

Regards!

Not applicable
Author

Perfect explanation. I now understand.