Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

karunpreet
Contributor

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

Re: Triggering a particular item of List Box

Yes, there is. Try expression:

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

11 Replies
jsingh71
Valued Contributor

Re: Triggering a particular item of List Box

Share your qvw with some sample data.

--Jai

MVP
MVP

Re: Triggering a particular item of List Box

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

Similarly for other sheet.

karunpreet
Contributor

Re: Triggering a particular item of List Box

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 ?

MVP
MVP

Re: Triggering a particular item of List Box

Yes, there is. Try expression:

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

karunpreet
Contributor

Re: Triggering a particular item of List Box

Thanks again Treseco  its working , You are awesome.

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

MVP
MVP

Re: Triggering a particular item of List Box

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

karunpreet
Contributor

Re: Triggering a particular item of List Box

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

karunpreet
Contributor

Re: Triggering a particular item of List Box

Thanks for your reply , but I got the solution

MVP
MVP

Re: Triggering a particular item of List Box


untitled.png

Community Browser