Hide a row in a list box

[#1]

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?

[IAMDV · Accepted solution]

Yes, it is possible to hide a row. You just need a simple expression in the ListBox. Let's say your field name is Budget. Then you would use something like this...

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

I hope this helps!

Cheers - DV

[its_anandrjs]

Hi,

Yes you can by this code use Match it is fast and easy

=If( Match(Budget, 'Budget 1'  ,  'Budget 2'  ,  'Budget 3'),Budget)

Rgds

Anand

[#4]

I've tried both:

IF(Scenario_ID<>'BUD', Scenario)

IF(Scenario_ID = 'BUD1' OR 'BUD2' OR 'BUD3', Scenario)

neither worked.

Current budget (with scenario_ID BUD) is still displayed, in addition some cryptic lines appear.

[IAMDV]

I think you should use..

=IF(Scenario_ID<>'BUD', Scenario_ID)

OR

=IF(Scenario_ID = 'BUD1' OR 'BUD2' OR 'BUD3', Scenario_ID)

Please post QV document if this doesn't work. But I am confident that this should work.

Cheers - DV

[IAMDV]

I still prefer the first solution.

=IF(Scenario_ID<>'BUD', Scenario_ID)

You are not not using the Scenario_ID and using Scenario.

Cheers - DV

[#7]

Nope doesnt work, tried your version as well (I have fields called both Scenario and Scenario_ID so it shouldnt make a difference).

If I don't have an expression i get the following content in my list box:

Budget 1

Budget 2

Budget 3

Current budget

Unknown

When i use

=IF(Scenario_ID<>'BUD', Scenario_ID)

I get the following content in my list box:

Budget 1  Budget 1

Budget 2  Budget 2

Budget 3  Budget 3

Current budget -

Unknow Unknown

So something does happen. Current budget only appears once while the others are duplicated. Any idea what i am doing wrong?

[IAMDV]

Oops! okay. Can you share the Scrambled QV document? It will be easy to work with the document. What are you trying to hide here? I mean do you want to hide unknown or Current budget?

Thanks - DV

[its_anandrjs]

Hi,

Use this code in the filter of list box

=If( Match(Scenario_ID, 'Budget 1'  ,  'Budget 2'  ,  'Budget 3'),Scenario_ID)

Rgds

Anand

[#10]

Nope, I get the same result - or I actually Unknown only appears once:

Budget 1  Budget 1

Budget 2  Budget 2

Budget 3  Budget 3

Current budget -

Unknow -

This is what I want my List box to contain:

Budget 1 

Budget 2 

Budget 3

Unknow