Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
Master II
Master II

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
Master II
Master II

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

Cheers - DV