Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
YoussefBelloum
Esteemed Contributor

Listbox with IF locked

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

Labels (3)
7 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Listbox with IF locked

HI,

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

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Listbox with IF locked

Hi Kaushik,

thank you,

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

is it a common behaviour ? 

Highlighted
MVP & Luminary
MVP & Luminary

Re: Listbox with IF locked

Yes,

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

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Listbox with IF locked

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 ?

Highlighted
MVP & Luminary
MVP & Luminary

Re: Listbox with IF locked

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

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
YoussefBelloum
Esteemed Contributor

Re: Listbox with IF locked

ok, thank you 

Highlighted
Bradleey
New Contributor

Re: Listbox with IF locked

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