topic Re: Activate Sheet logic in QlikView

Activate Sheet logic

abhaysingh — Sat, 11 Oct 2014 14:21:32 GMT

I want the logic that if I select Particular field value than other sheet will activate..

is it possible?????

Re: Activate Sheet logic

Anonymous — Sat, 11 Oct 2014 14:38:50 GMT

Hi,

navigate to document properties -> triggers. Search the field which will trigger the sheet under Field event Triggers, and use an expression like this:

=if(match(YEAR, 2013), 'SH02')

where YEAR is the field which the selection is apllied to, and '2013' the Value you want to apply the action to and SH02 the sheet ID which should be activated.

Best Regards

Stefan

Re: Activate Sheet logic

abhaysingh — Sat, 11 Oct 2014 14:57:27 GMT

I have town values like japur, rajasthan etc...and it comes under the field OfficerTown

it is giving error pls help

Re: Activate Sheet logic

Anonymous — Sat, 11 Oct 2014 15:02:13 GMT

Hi,

use this expression in the activate sheet action (Layout) you add to the field trigger:

=if(match(OfficerTown, 'japur', 'rajasthan'), 'YOURSHEETID')

if this doen't help, please post a sample qvw.

Best regards

Stefan

Re: Activate Sheet logic

abhaysingh — Sat, 11 Oct 2014 15:05:00 GMT

there are so many values in officer not only two

Re: Activate Sheet logic

abhaysingh — Sat, 11 Oct 2014 15:10:47 GMT

There are so many values in officerTown field I want to do it for all

Re: Activate Sheet logic

Anonymous — Sat, 11 Oct 2014 15:12:35 GMT

Hi,

ah ok. Then simply type the sheetId of the sheet you want to activate instead of the expression. Thought you only wanted the sheet for specific Values.

Best

Stefan

Re: Activate Sheet logic

abhaysingh — Sat, 11 Oct 2014 15:14:45 GMT

not working

Re: Activate Sheet logic

Sat, 11 Oct 2014 15:36:16 GMT

Hi Abhay,

In the field triggers select the field on which you want to add the trigger.

click on "On Select" add actions --> Layout-->Activate Sheet give the sheetID which you want to activate.

Similarly do this on "On change" as well.

Check out the attached image.