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: 
Anonymous
Not applicable

Triggering a particular item of List Box

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Yes, there is. Try expression:

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

View solution in original post

11 Replies
jsingh71
Partner - Specialist
Partner - Specialist

Share your qvw with some sample data.

--Jai

tresesco
MVP
MVP

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

Similarly for other sheet.

Anonymous
Not applicable
Author

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
MVP
MVP

Yes, there is. Try expression:

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

Anonymous
Not applicable
Author

Thanks again Treseco  its working , You are awesome.

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

tresesco
MVP
MVP

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

Thanks for your reply , but I got the solution

tresesco
MVP
MVP


untitled.png