topic Re: activate a sheet within a sheet in QlikView

activate a sheet within a sheet

Fri, 15 Nov 2013 13:51:21 GMT

In this demo that I saw online (attached), I saw that there are text objects "sales overview," "what-if?" and "order details" that activate sheets when clicked.

But these sheets appear to be on the same main sheet as sales analysis. How is that being done?

Normally if I activate a sheet, it moves me to another tab in the qvw. Thoughts?

Re: activate a sheet within a sheet

Anonymous — Fri, 15 Nov 2013 15:00:26 GMT

These are not sheet, they are designed to appear like a sheet.

Its just an image and all other objects are activated or deactivated using the conditional show option.

How to check? - delete the buttons with the text and then right click and check the properties of the text object that bears the image.

Re: activate a sheet within a sheet

MK_QSL — Fri, 15 Nov 2013 15:00:49 GMT

There are three sheets having same documents and layout.... each having different SHEET ID.

You can see SHOW SHEET is having conditional Expression...

i.e. vSalesAnalysis=2

Also all three TEXT OBJECT are having same type of condition

Once you click on Order Details,

it will having a trigger which will make vSalesAnalysis = 3 and Activate SH14....

It's so simple at last but made very tricky using CONDITIONAL SHOW.....

Re: activate a sheet within a sheet

MK_QSL — Fri, 15 Nov 2013 15:09:40 GMT

Check enclosed file as an example

Re: activate a sheet within a sheet

Anonymous — Fri, 15 Nov 2013 15:10:57 GMT

agreed... indeed its a smart way to do.

at my first impression thought this would be a conditional show option that the developer has used.

Yes, I am surprised.

Re: activate a sheet within a sheet

Fri, 15 Nov 2013 20:30:45 GMT

Thank you. Once that point became clear, I was able to duplicate it in another qvw. Thanks again.

Re: activate a sheet within a sheet

Tue, 19 Nov 2013 10:05:30 GMT

Hi,

your example really helped me, but if it is 2 different sheets, then why can't I see them under VIEW->SHEETS and I see only one sheet?

also, in the Demo I couldn't find the this Actions as you did in your example.

Thanks,

Boris

Re: activate a sheet within a sheet

MK_QSL — Tue, 19 Nov 2013 10:35:46 GMT

Check under....

Document Properties

Sheets...

Re: activate a sheet within a sheet

Tue, 19 Nov 2013 11:53:41 GMT

Thanks!

Re: activate a sheet within a sheet

Tue, 19 Nov 2013 14:08:22 GMT

Also check, document properties, security, and then check "show all sheets and objects."