Triggering a particular item of List Box

[Anonymous]

I have a field called Measure and the items in them are Call Out and Energy. I have displayed the same in a List-Box.

Also I have 2 different sheets for Call Out and Energy. My user requires that when I click on Call Out from the List-Box the 'Call Out' sheet  ( which is actually hidden ) gets activated . Similar is the case with 'Energy'.

Please help me with this issue as its urgent.

Thanking everyone in anticipation

[jsingh71]

Share your qvw with some sample data.

--Jai

[tresesco]

Goto Sheet 'Energy'->Right Click->Properties->General Tab-> Show Sheet (Conditional) ->Expression =Measure='Energy'

Similarly for other sheet.

[Anonymous]

Tresesco, Thanks for your reply , its working for me, but still this solution has a drawback, as soon as I select both the measures-> Call Out and Energy ,QlikView takes me back to my home page. Any solution for that ?

[tresesco · Accepted solution]

Yes, there is. Try expression:

=Index(GetFieldSelections(Measure) , 'Energy')

[Anonymous]

Thanks again Treseco  its working , You are awesome.

Last doubt, waht if I want to activate that sheet ?

[tresesco]

You have to use a trigger in that case. Document properties-> Triggers-> Field event trigger-> On select-> Action(Layout->Activate Sheet)

[Anonymous]

There is no On Select Option in my QlikView, I have OnAnySelect Option

[Anonymous]

Thanks for your reply , but I got the solution

[tresesco]