Discussion Board for collaboration on QlikView Layout & Visualizations.
I want to activate a sheet on the basis of field selections PFA
Go to Solution.
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.
Means you want to go to perticular sheet or unhide that sheet
Thanks & Regards
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!
In sheet properties -> General -> show sheet option -> in conditional option ->
copy a code like =GetSelectedCount(ListboxField)
Hope this helps
Goto Sheet property> General > show conditional
I want to navigate to particular sheet
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,
I need to navigate to sheet1 when the graphtype=penality
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)
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)