topic Re: Selecting in a list box using another list box in QlikView

Selecting in a list box using another list box

ahammadshafi — Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts:

In the original client source file there are 6 currencies - they are populated in a list box; named "Currency". But the client wants that users will have another list box (named "InLineCurrency") which will have a fixed sub set of the 6 currencies and a new one named "LC" (Local Currency).

The requirement:

1. If the user selects "LC" from "InLineCurrency" no item will be selected in "Currency" listbox.

2. If the user selects "USD" from "InLineCurrency", "USD" will be selected in "Currency" listbox.

Please find a sample QVW file as attachment.

Regards,

Shafi

Re: Selecting in a list box using another list box

adamdavi3s — Wed, 12 Oct 2016 06:47:03 GMT

Hi Shafi,

I would probably use a field trigger for this.

I will make an example.

Re: Selecting in a list box using another list box

ahammadshafi — Wed, 12 Oct 2016 06:48:37 GMT

Hi Adam:

I am looking forward to the example; thanks.

Shafi

Re: Selecting in a list box using another list box

adamdavi3s — Wed, 12 Oct 2016 06:50:38 GMT

Here you go, You could also use different formula to do this if you wanted e.g if selection = LC select nothing, else select InLineCurrency as they are the same

Re: Selecting in a list box using another list box

adamdavi3s — Wed, 12 Oct 2016 06:52:52 GMT

Ok here is an example with the IF as well, which will obviously improve things if you want to add more to your inline.

Note that we use actions on both the select AND on change to handle this.

And these are in settings > document properties > triggers, in case you haven't used them before.

Re: Selecting in a list box using another list box

ahammadshafi — Wed, 12 Oct 2016 06:56:05 GMT

Hi Adam:

Many thanks. You are absolutely right, I didn't use field trigger before.

Shafi

Re: Selecting in a list box using another list box

tamilarasu — Wed, 12 Oct 2016 06:57:28 GMT

Hui Ahammad,

You can simply try like below screenshot.

Re: Selecting in a list box using another list box

adamdavi3s — Wed, 12 Oct 2016 07:01:01 GMT

No problem, they're very useful but a pain when you're debugging and forget that they are there!

Re: Selecting in a list box using another list box

ahammadshafi — Wed, 12 Oct 2016 07:01:13 GMT

Many thanks Nagaraj.

That's an even better solution ...

Re: Selecting in a list box using another list box

ahammadshafi — Wed, 12 Oct 2016 07:02:43 GMT

Many thanks Adam for mentioning it.

Re: Selecting in a list box using another list box

adamdavi3s — Wed, 12 Oct 2016 07:03:58 GMT

IMHO this is a little dirty as it relies on LC causing a select error... but that is just my opinion!

Re: Selecting in a list box using another list box

ahammadshafi — Wed, 12 Oct 2016 07:07:51 GMT

Understood.

So many thanks for your opinion. Opinions are always helpful to learns things and best practices....

Shafi

Re: Selecting in a list box using another list box

tamilarasu — Wed, 12 Oct 2016 07:17:21 GMT

I think, it will not affect anything in the dashboard. Since you find this dirty, I will suggest an alternate one,

=Replace(GetFieldSelections(InLineCurrency),'LC','')

Re: Selecting in a list box using another list box

adamdavi3s — Wed, 12 Oct 2016 07:24:07 GMT

No of course it won't, it is standard Qlik functionality... My reason behind finding it dirty is that it somewhat hides the intended purpose by not explicitly having LC in the formula.

This makes it harder to understand if anyone else were to pick up and try and develop the dashboard.

That example is better indeed

Re: Selecting in a list box using another list box

tamilarasu — Wed, 12 Oct 2016 07:48:29 GMT

I agree. I thought of providing a simple solution and I didn't think from this point of view.

Re: Selecting in a list box using another list box

adamdavi3s — Wed, 12 Oct 2016 07:52:27 GMT

That's what is good about this community