Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
Yes if you go to sheet properties in general tab you will see "Show Sheet" option.
Choose "Conditional" and use the below expression.
i would create a variable --> Variable =if(price<=0, 0, 1) and then set a condition for showing the sheet Variable =1
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.
Sorry i have one more question.
What if u want to hide it based on a string i a listbox?
But some customers only have TypeA and TypeC, so those who doesnt have TypeB should have the sheet or object hidden.
You are right.
I just cant get it to work?