QlikView App Dev

[#1]

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.

[julian_rodriguez · Accepted solution]

Hello Dennis

Try with this expression:

=Only({<car=>}car_name)

Regards

[ecolomer]

Is this you need?

[#4]

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

[#5]

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?

[#6]

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]

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!

[#8]

Perfect explanation. I now understand.