hide sheet based on no price

[#1]

Hello,

I have this secarnio:

I one qvw file, which is distributed to 20 customers, so they have their own.

I this qvw file i have a tab called products, which show some prices. But some of my customers, dont have prices, and therefore the product tab is not relevant.

How do i hide the sheet for those whom do not have any prices?

Is it a conditional on sheet which just sum price and if it is < 0 then hide? or?

[kaushiknsolanki · Accepted solution]

Hi,

     Yes if you go to sheet properties in general tab you will see "Show Sheet" option.

     Choose "Conditional" and use the below expression.

     if(sum({1}Price)>0,1,0)

Regards,

Kaushik Solanki

[michael_maeuser]

i would create a variable --> Variable =if(price<=0, 0, 1) and then set a condition for showing the sheet Variable =1

[#4]

Hi Thomas,

That sounds like a good place to start.

Sum(Price) > 0 would be your show condition in your sheet property. The sheet will show when the condition evaluates to true.

Andy

[#5]

Sorry i have one more question.

What if u want to hide it based on a string i a listbox?

Eg.

I have:

TableTypes:

TypeA

TypeB

TypeC

But some customers only have TypeA and TypeC, so those who doesnt have TypeB should have the sheet or object hidden.

If(wildmatch(TableTypes='*B*,1,0) ??

[kaushiknsolanki]

Hi,

You are right.

Regards,

Kaushik Solanki

[#7]

I just cant get it to work?