topic Conditional Display in sheets in QlikView

Conditional Display in sheets

Tue, 03 Jan 2012 11:07:22 GMT

Hi All,

I have requirement is like in my report i have some sheets from those am dispplaying some sheets with conditional display and i have 2 sheets (Intro,Howto) for these 2 sheets dnot require conditional display. From this file whenever if i click sheet1,sheet2.....etc respective sheet sholud disaply but if i click any of the sheet from list box its taking me to directly intro sheet. How to fix this......i have attached sample file here

Re: Conditional Display in sheets

swuehl — Tue, 03 Jan 2012 11:42:56 GMT

You could use a trigger on changes on field A with an layout action of type acitvate sheet. See attached.

Conditional Display in sheets

Tue, 03 Jan 2012 13:42:40 GMT

HI swuehl thnx for replay its perfectly working for sheet2,sheet3 but for sheet1 its again moving just have look it and

where do i change/apply triggers and any more changes in sheet.

Re: Conditional Display in sheets

swuehl — Tue, 03 Jan 2012 13:46:30 GMT

It's not moving, your Sheet1 is activated and visibile on the position that you created it. If you want it to be displayed after the how-to tab, you need to move / promote your sheet once with the appropriate menu command. See attached.

Conditional Display in sheets

Tue, 03 Jan 2012 13:52:24 GMT

yes yes...now its working perfectly......thnx swuehl but where i have to apply this triggers and all could you please explain it beacuse am not getting how to do this....

Conditional Display in sheets

swuehl — Tue, 03 Jan 2012 13:57:12 GMT

Go to Settings - document properties - triggers.

There are two actions (identically) set on Field Event Triggers for field A (OnSelect / OnChange).

Note that I renamed the sheet IDs of those sheets to be identically with your Field A values, so I can just use =A as expression for the activate sheet action (See sheet properties - general tab).