topic Select a sheet by selecting a value from a multibox in QlikView

Select a sheet by selecting a value from a multibox

hopkinsc — Fri, 17 Sep 2010 11:37:10 GMT

Hi, i have a multibox with various options.

Transactions

Sales

Operational

This multibox is on my SELECTIONS tab. Basically the user will select what it is they wish to look at (eg, Transactions) then a drop down list of available options appear

Transactions

Refunds

Voids

Paid Outs

Staff Discount

etc

If the user then selects 'Refunds', i then want the user to be automatically taken to the 'Refunds' tab.

Is this possible?

Select a sheet by selecting a value from a multibox

Fri, 17 Sep 2010 11:55:56 GMT

Hi,

You can use conditional show option in sheet property and achieve this.

Take for example you user select 'Refund'

Right click on Refund sheet and Go to Sheet property ---> General .--> Conditional Show

your expresion should be as follow.

Field Name = 'Refund'

Hope this may help you.

- Sridhar

Select a sheet by selecting a value from a multibox

hopkinsc — Fri, 17 Sep 2010 12:15:06 GMT

Thats fine for showing the sheet, but i also want the user to be taken to that sheet without having to click on 'Refunds' then click on the sheet tab.

I have looked in the triggers and tried to set up 'LAYOUT', and 'ACTIVATE SHEET' but it just askes for a sheet id. I was hoping i could use an expression to say that when REFUNDS are selected, actovate the Refunds sheet.

Select a sheet by selecting a value from a multibox

Fri, 17 Sep 2010 12:46:35 GMT

Hi,

Sry, i dnt completely uderstood your question earlier.

you can do this using macro.

you macro should be similar as follow. (Untested macro)

sub ACTIVATESHEET

set val=ActiveDocument.Fields("Field").GetSelectedValues
ActiveDocument.Variables("variField").SetContent val.item(0).text, true

IF variField = 'REFUND' THEN
ActiveDocument.Sheets("REFUND").Activate

ENDIF variField = 'VOIDS' THEN
ActiveDocument.Sheets("VOIDS").Activate
END

End Sub

Map this function to on chnage field trigger in document property.

- Sridhar

Select a sheet by selecting a value from a multibox

Fri, 17 Sep 2010 13:15:34 GMT

Hi,

You can use "Triggers" to resolve this problem.

In Documents Properties, "Triggers", "Field Event Triggers", "On Selection".

Add / Layout / Activate Sheet.

In field "Sheet ID" you need the sheet that you want to show.

See the example.

Select a sheet by selecting a value from a multibox

hopkinsc — Fri, 17 Sep 2010 13:30:22 GMT

Thanks Eduardo, Thats exactly what i wanted..