topic Re: listbox expression disabled for gray items in QlikView

listbox expression disabled for gray items

Wed, 01 Oct 2014 21:08:37 GMT

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.

Re: listbox expression disabled for gray items

julian_rodriguez — Wed, 01 Oct 2014 21:14:22 GMT

Hello Dennis

Try with this expression:

=Only({<car=>}car_name)

Regards

Re: listbox expression disabled for gray items

ecolomer — Wed, 01 Oct 2014 21:17:23 GMT

Is this you need?

Re: listbox expression disabled for gray items

Wed, 01 Oct 2014 22:07:29 GMT

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

Re: listbox expression disabled for gray items

Wed, 01 Oct 2014 22:19:49 GMT

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?

Re: listbox expression disabled for gray items

Wed, 01 Oct 2014 22:26:06 GMT

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.

Re: listbox expression disabled for gray items

julian_rodriguez — Wed, 01 Oct 2014 22:31:58 GMT

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!

Re: listbox expression disabled for gray items

Thu, 02 Oct 2014 00:33:33 GMT

Perfect explanation. I now understand.