Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

hide sheet based on no price

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?

Tags (2)
1 Solution

Accepted Solutions

Re: hide sheet based on no price

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

6 Replies

Re: hide sheet based on no price

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
Contributor III

Re: hide sheet based on no price

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

Not applicable

Re: hide sheet based on no price

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

Not applicable

Re: hide sheet based on no price

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

Hi,

You are right.

Regards,

Kaushik Solanki

Not applicable

Re: hide sheet based on no price

I just cant get it to work?