topic Hide grayed out data from List box when a value is selected in QlikView

Hide grayed out data from List box when a value is selected

alec1982 — Fri, 03 Jan 2014 21:13:19 GMT

Hello,

I am not sure if there is another way of doing this beside the below but would love to get opinions..

I need to hide grayed out data when a value in a list box is checked..

The only way so far is by going into the list box option and check hide excluded..

Any other suggestions?

Thxs,

Alec

Re: Hide grayed out data from List box when a value is selected

alec1982 — Fri, 03 Jan 2014 21:27:28 GMT

In other way assuming I have two list boxes One called Client and one called address

If I select Client A from Client then all addresses related to other client will be grayed out..

Is there anything i could use within the expression of the list box to show data where client = getfieldselections value of Clients equal the selected client?

Re: Re: Hide grayed out data from List box when a value is selected

Fri, 03 Jan 2014 21:32:25 GMT

You could use an expression in the list box, but I am not sure how well it would perform on very large data sets. Try something like:

=if(Aggr(FindOneOf(YourAddressField,Concat(Chr(39) & YourAddressField & Chr(39),', ')),YourAddressField)=1,YourAddressField)

This way onle the related items will show in white; nothing will show in gray.

Re: Hide grayed out data from List box when a value is selected

alec1982 — Fri, 03 Jan 2014 21:40:53 GMT

Hi Rebecca,

Thank you for your help but it doesn't work. the expression returned only 1170 value while the total values should be 1176.

Thxs,

Alec

Re: Re: Hide grayed out data from List box when a value is selected

Fri, 03 Jan 2014 21:49:51 GMT

Hmm. Do you have some sample data? It works for me.

Re: Hide grayed out data from List box when a value is selected

agilos_mla — Fri, 03 Jan 2014 21:53:48 GMT

Hi Badr,

You can simply try this in the list box expression :

=aggr(Concat(DISTINCT{<Client=P(Client)>}Address), Address)

KR,

Michael

Re: Hide grayed out data from List box when a value is selected

alec1982 — Fri, 03 Jan 2014 21:56:13 GMT

this works exactly as the hide excluded on the list box option..

I need the values to be hidden based on the client name same to what we do set analysis expression and we enter the client name..

Thxs,

Alec

Re: Hide grayed out data from List box when a value is selected

Fri, 03 Jan 2014 21:58:20 GMT

Guess I don't understand what you're looking for then. If you have an example, we can probably help.

Re: Hide grayed out data from List box when a value is selected

alec1982 — Fri, 03 Jan 2014 22:01:06 GMT

Both of the expression are correct but they both work similar to hide excluded check box.

The problem is if I apply the expression and then filter the clients on Client A it will show its related addresses in the address list box then If i filter on one of the addresses the other addresses will be hidden. while I need to hide the data based on the client name then when I apply other filters the unrelated data will be grayed out..

Hope that explain it..

Thxs,

Alec

Re: Hide grayed out data from List box when a value is selected

rustyfishbones — Fri, 03 Jan 2014 22:06:34 GMT

Hi Rebecca,

you don't need the long expression

try

AGGR(Address,Address)

it works fine

Re: Hide grayed out data from List box when a value is selected

rustyfishbones — Fri, 03 Jan 2014 22:08:10 GMT

try

AGGR(Address,Address)

does the same as the suggestions above, but much easier to remember

Thanks

Alan

Re: Hide grayed out data from List box when a value is selected

agilos_mla — Fri, 03 Jan 2014 22:09:58 GMT

Then,

You've had to disable the address selection in the set analysis.

=aggr(Concat(DISTINCT {<Client=P(Client), Address=>} Address), Address)

Re: Hide grayed out data from List box when a value is selected

rustyfishbones — Fri, 03 Jan 2014 22:23:42 GMT

Is there a need for that?, I don't think there is

Re: Hide grayed out data from List box when a value is selected

Fri, 03 Jan 2014 22:30:22 GMT

Alan - why would I want something simple when something complicated/long works just as well? Thanks Alan!

Re: Hide grayed out data from List box when a value is selected

rustyfishbones — Fri, 03 Jan 2014 22:33:07 GMT

I mean this in the nicest possible way, but you sound like my wife

it's good to know a few ways though!

Re: Hide grayed out data from List box when a value is selected

rustyfishbones — Fri, 03 Jan 2014 22:38:02 GMT

BTW

Love your Qlikview Design Blog http://intuiqlik.com/

Re: Hide grayed out data from List box when a value is selected

alec1982 — Fri, 03 Jan 2014 22:38:16 GMT

Thanks all for your help!

Re: Hide grayed out data from List box when a value is selected

rbecher — Fri, 03 Jan 2014 22:42:34 GMT

..or

=Aggr(Only(Address), Address)

This gives you the possibility to use an additional set analysis in Only() if needed.

- Ralf

Re: Hide grayed out data from List box when a value is selected

rbecher — Fri, 03 Jan 2014 22:43:55 GMT

I think Concat will be really slow on a big data set..

Re: Hide grayed out data from List box when a value is selected

rustyfishbones — Fri, 03 Jan 2014 22:49:20 GMT

Thanks Ralf,

I will remember that tip