topic Re: hide sheet based on no price in QlikView

hide sheet based on no price

Mon, 02 Sep 2013 07:50:05 GMT

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?

Re: hide sheet based on no price

kaushiknsolanki — Mon, 02 Sep 2013 07:53:23 GMT

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

Re: hide sheet based on no price

michael_maeuser — Mon, 02 Sep 2013 07:53:25 GMT

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

Re: hide sheet based on no price

Mon, 02 Sep 2013 07:53:53 GMT

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

Re: hide sheet based on no price

Mon, 02 Sep 2013 14:08:16 GMT

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) ??

Re: hide sheet based on no price

kaushiknsolanki — Mon, 02 Sep 2013 14:35:29 GMT

Hi,

You are right.

Regards,

Kaushik Solanki

Re: hide sheet based on no price

Mon, 02 Sep 2013 14:40:47 GMT

I just cant get it to work?