Selecting in a list box using another list box

[ahammadshafi]

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

[adamdavi3s]

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

[ahammadshafi]

Understood.

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

Shafi

[tamilarasu]

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','')

[adamdavi3s]

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

[tamilarasu]

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

[adamdavi3s]

That's what is good about this community