topic How do I make a sheet appear when I make a selection? in QlikView

How do I make a sheet appear when I make a selection?

Tue, 01 Mar 2011 12:06:01 GMT

I want to know how I can show and activate a sheet as soon as I click on a value in either a list box or a table. I have a list of names in a table and I have created a sheet showing a detailed view of that person. I don't want to show the sheet but hide it and only open it if and only if someone clicks on a name in my table or list box.

Thanks

Rajesh

How do I make a sheet appear when I make a selection?

Tue, 01 Mar 2011 12:11:21 GMT

Hi,

Go to sheet properties

General-------> Show sheet------>Conditional

Put the condition as per the values in the list box

Thanks & Regards

Upendra

How do I make a sheet appear when I make a selection?

Wed, 14 Dec 2011 14:10:28 GMT

General-------> Show sheet------>Conditional

if(len(GetFieldSelections(namefiled))<>0,1,0)

bye

How do I make a sheet appear when I make a selection?

jagan — Thu, 15 Dec 2011 15:32:49 GMT

Hi,

Go to sheet properties

General-------> Show sheet------>Conditional

Use the following expression

If(GetSelectedCount(FieldName) > 0, 1, 0)

Hope this helps you.

Regards,

Jagan.