Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide a row in a list box

I want to hide a row in one of my list boxes. The list box is my table Scenario, where I have "Budget 1" "Budget 2" "Budget 3" and "Current budget". The last one will always represent Budget 1, 2 or 3. Having a current budget makes it a whole lot easier when creating static tables, however it does make it (only slightly) confusing as there are two rows that represent the same data. So my question is, is it possible to hide this row?

12 Replies
IAMDV
Luminary Alumni
Luminary Alumni

What is the name of this Field? Is it Scenario or Scenario_ID?

If it is Scenario then use :

=IF(Scenario <> 'Current budget', Scenario)

If it is Scenario_ID then use :

=IF(Scenario_ID <> 'Current budget', Scenario_ID)

Can you post the QV document? or the screenshot?


Not applicable
Author

Thanks for your help! I now figured out what i had done wrong. I had chosen field Scenario and in addition written an expression  instead of chosing expression as a field.... Me being a bit slow

Thanks again

IAMDV
Luminary Alumni
Luminary Alumni

You are welcome! I am glad you have got it working.

Cheers - DV