topic Re: Listbox with IF locked in QlikView

Listbox with IF locked

YoussefBelloum — Sat, 16 Nov 2024 19:07:39 GMT

Hi everyone,

I'm using listboxes for my calendar year field.

I needed to add an IF and use an expression inside the listboxes to filter on certain values.

With that IF and as soon as I select a value, my listbox are locked and I can't remove that value with selecting it again on the listbox, the only way to deselect the value is to use the DELETE button (the one that deletes all the values from all the fields) and that's not really what I need...

Maybe be it is a common behavior but it's the first time I see this...

Is there a solution to solve this problem ? something to add on the expression ?

Thank you

Re: Listbox with IF locked

kaushiknsolanki — Wed, 12 Feb 2020 17:20:29 GMT

HI,

Best way is to create that as added filter in script.

Anyways, what is the expression (If Statement) you wrote?

Re: Listbox with IF locked

YoussefBelloum — Wed, 12 Feb 2020 18:48:35 GMT

Hi Kaushik,

thank you,

the expression is like this: if(flag=value, year)

is it a common behaviour ?

Re: Listbox with IF locked

kaushiknsolanki — Thu, 13 Feb 2020 05:37:46 GMT

Yes,

In your case the behavior is expected, because your selection is driven by flag field.

Re: Listbox with IF locked

YoussefBelloum — Thu, 13 Feb 2020 14:10:35 GMT

I've created a test app with flag,year,measure structure and listbox with an IF like described above, and I can select and deselect year values without any issue.. so maybe there is something missing on your explanations ?

Re: Listbox with IF locked

kaushiknsolanki — Fri, 14 Feb 2020 05:32:18 GMT

No, Because When I did, I had similar problem.

So the best way is to create such filters in script than on frontend.

Re: Listbox with IF locked

YoussefBelloum — Fri, 14 Feb 2020 09:36:48 GMT

ok, thank you

Re: Listbox with IF locked

Bradleey — Sat, 15 Feb 2020 09:44:11 GMT

I have a listbox whose listrange is set via vba. Upon opening the workbook, the list is set fine; however, when you click on it, no items can be selected, nor can you scroll the list krogerfeedback.com