Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

activation of sheet

Hi all,

I want to activate a sheet on the basis of  field selections PFA

1 Solution

Accepted Solutions
Not applicable

Re: Re: activation of sheet

Then just add the similar condition on Sheet 2 :

=GetFieldSelections(graph_type) = 'netdelay'

And, edit the Field event trigger as:

=If(graph_type = 'penality','SH02',

If(graph_type = 'netdelay','SH03'))

PFA, the modified file.

15 Replies

Re: activation of sheet

Means you want to go to perticular sheet or unhide that sheet

Thanks & Regards

Not applicable

Re: activation of sheet

Hi,

PFA. You have to add trigger/action on that field.

I have assumed that you need to activate the sheet "Sheet 1" on the basis of selection in the field "graph_type"
Hope this helps!

Re: activation of sheet

Hi,

In sheet properties -> General -> show sheet option -> in conditional option ->

copy a code like =GetSelectedCount(ListboxField)

Hope this helps

Thanks & Regards

sushil353
Honored Contributor II

Re: activation of sheet

hi,

Goto Sheet property> General > show conditional

=if(getfieldselections(graph_type)='netdelay',1,0)

HTH

Sushil

Not applicable

Re: activation of sheet

Hi Anand,

I want to navigate to particular sheet

Re: activation of sheet

Hi,

In your example you can add Three Buttons or Text Boxes ,

Give Proper Name,

then Go to Property window->Action Tab->Add->Layout->ActivateSheet->give Sheet Id,

Regards,

Regards,
Prashant Sangle
Not applicable

Re: activation of sheet

Hi Shymal,

  I need  to navigate to sheet1  when the graphtype=penality

sushil353
Honored Contributor II

Re: activation of sheet

You can add listbox to every sheet and add condition to specific sheet .. for example if you have say 3 sheet and

your data in listbox is netdelay,payout and penality..

then for sheet 1 put condition = =if(getfieldselections(graph_type)='netdelay',1,0)

for sheet 2 put condition = =if(getfieldselections(graph_type)='payout ',1,0)

for sheet 3 put condition = =if(getfieldselections(graph_type)='penality',1,0)

HTH

Sushil

Not applicable

Re: activation of sheet

Hi Max,

  But the sheet should activate on the basis of selection I.e  if the graphtype=penality then sheet 1 should activate

(not display or hiding)

Community Browser