Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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.

View solution in original post

15 Replies
its_anandrjs

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

Thanks & Regards

Not applicable
Author

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!

its_anandrjs

Hi,

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

copy a code like =GetSelectedCount(ListboxField)

Hope this helps

Thanks & Regards

sushil353
Master II
Master II

hi,

Goto Sheet property> General > show conditional

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

HTH

Sushil

Not applicable
Author

Hi Anand,

I want to navigate to particular sheet

PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable
Author

Hi Shymal,

  I need  to navigate to sheet1  when the graphtype=penality

sushil353
Master II
Master II

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
Author

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)