topic Re: How can slider values affect selection? in QlikView

How can slider values affect selection?

Thu, 06 Dec 2012 15:28:53 GMT

Hello All,

I am using comparative analysis to compare clients and their peers. I have 2 multi-boxes for selection purposes to choose clients and peers using different characteristics. We also want the help user to compare comparable clients (i.e. revenue is in given band) by using sliders. Once the user sets the slider's min and max values; we would want clients (in multibox dropdown) to be excluded from selection. How can this be done (triggers, scripting, any other ideas)?

Thanks,

Ronak

Re: How can slider values affect selection?

vgutkovsky — Thu, 06 Dec 2012 16:42:07 GMT

I think you would the best visual appearance by using an aggr() expression as your multibox field. Something like this:

aggr(

if(sum(revenue)>=vMinValue and sum(revenue)<=vMaxValue,client)

,client

)

Regards,

Vlad

Re: How can slider values affect selection?

Thu, 06 Dec 2012 17:09:53 GMT

Thanks Vlad. I could not find Visual Appearance for multibox field. However, I did take your idea and created new expression as my multibox field and it achieves the same result.

Re: How can slider values affect selection?

vgutkovsky — Thu, 06 Dec 2012 19:55:38 GMT

That's what I meant. Visual appearance was just an English term not a technical term

Vlad