topic Re: Listbox filter in QlikView

Listbox filter

Mon, 04 Feb 2013 12:39:12 GMT

Hello,

My data looks like that:

I want to create a listbox that shows only FieldB for FieldA = Y.

I can do that easily with =if(FieldA=Y,FieldB) but I have 4 listboxs that work this way in my dashboard and that is resulting in a perfomance loss.

I think there is a way to do that with some aggregation function, but I just dont know how to do it.

Thanks for any help!

Att,

Luiz Fernando

Mon, 04 Feb 2013 12:48:33 GMT

I'm not sure but You still will not be able to do it without using =if() so it will not increase performance

Tue, 05 Feb 2013 15:25:31 GMT

Oh... thats bad.

But thanks anyway!

Caique_Zaniolo — Tue, 05 Feb 2013 15:33:32 GMT

Is the condition always the same? If that is the case you can create a new Field in your table containing only the values you need.

Tue, 05 Feb 2013 15:54:30 GMT

No, its not. I'd have to create more tables

Tue, 05 Feb 2013 16:26:07 GMT

Verify this way helps.

Creates a expression field and define:

=Aggr(ONLY({<FieldA={'Y'}>} FieldB), FieldB)

The use of set analisys can help in the matter of performance.

Tue, 05 Feb 2013 16:51:09 GMT

It works!

But I've had to add =Aggr(ONLY(1{<FieldA={'Y'}>} FieldB), FieldB), so the listbox doesnt lose it's normal functionality

Thank you very much!