Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Yes, there is. Try expression:
=Index(GetFieldSelections(Measure) , 'Energy')
Share your qvw with some sample data.
--Jai
Goto Sheet 'Energy'->Right Click->Properties->General Tab-> Show Sheet (Conditional) ->Expression =Measure='Energy'
Similarly for other sheet.
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 ?
Yes, there is. Try expression:
=Index(GetFieldSelections(Measure) , 'Energy')
Thanks again Treseco its working , You are awesome.
Last doubt, waht if I want to activate that sheet ?
You have to use a trigger in that case. Document properties-> Triggers-> Field event trigger-> On select-> Action(Layout->Activate Sheet)
There is no On Select Option in my QlikView, I have OnAnySelect Option
Thanks for your reply , but I got the solution