Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
i would create a variable --> Variable =if(price<=0, 0, 1) and then set a condition for showing the sheet Variable =1
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
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) ??
Hi,
You are right.
Regards,
Kaushik Solanki
I just cant get it to work?