Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Default Sheet to show on open

Hi,

Please look into below screen shot from the screen shot i have Dashboard frm that i have sheets starting from shair main dashboard to Trendingand am displaying all sheets with condtional display using the belowcondition for  shair main dash board sheet =[ShairA&I]='SHAIR MainDasboard' and for Infrastructure sheet am using

=[ShairA&I]='SHAIR Main Dasboard/Infrastructure'...............for all sheets....

here what i want is when ever we open the Dashboard it should open withthe Shair main Dashboard sheet this is the start up page of thedashboard,,,, suppose if we save the Dashboard in Server sheet if weopened next time instead of opening with Server Sheet it should openwith Shair Main Dashboard sheet.......

1234.JPG

Regards,

Anil

1 Solution

Accepted Solutions
MVP
MVP

Re: Default Sheet to show on open

Hi,

Please check the attached file.  It is working as you expected.

I added one more action to selest the field.

Regards,

Jagan.

11 Replies
jason_michaelid
Honored Contributor II

Default Sheet to show on open

Settings > Document Properties > Triggers

Set a Layout > Activate Sheet action OnOpen.

Hope this helps,

Jason

MVP
MVP

Default Sheet to show on open

Hi,

Do the following

Settings Menu -> Document Properties -> Triggers -> Document Event Triggers (on Open) -> Add -> Layout -> Activate Sheet-> Give sheet name (you required).

Hope this helps you.

Regards,

Jagan.

Not applicable

Default Sheet to show on open

   Hi,

       Jason/Jagan thanx for your quick reply i have tried this but no use after applying this i saved the file and reopened but its opening where i was closed the file not opens from Shair Main Dashboard.

 

please suggest  any  other way if we have

Regards,

Anil


jason_michaelid
Honored Contributor II

Default Sheet to show on open

Can you post your app?

MVP
MVP

Default Sheet to show on open

Hi Anil,

Make sure that you given the Sheet ID instead of Sheet Caption.

Regards,

Jagan.

Not applicable

Default Sheet to show on open

  Yes i have given Sheet Caption only earlier i have changed sheet id with sheet name for other requirement i.e   coditional display of sheets..

Not able to upload the sample file its huge file......

Regards,

Anil

jason_michaelid
Honored Contributor II

Default Sheet to show on open

So are you using the caption or the ID in the Action?

kuba_michalik
Contributor III

Default Sheet to show on open

So, you are showing a sheet based on selection in a field. Selection state gets saved too, and because of that you can activate the sheet with an Action all you want, but if a sheet is invisible, it just won't work :-)

Do put an Action on OnOpen, but make it Select in Field. Field=[ShairA&I], Search String='SHAIR MainDasboard'. The sheet should show automatically.

Not applicable

Re: Default Sheet to show on open

Jason,,Am using caption only not ID....

Any way i have attcahed sample file here,, whenever we opened the Dashboard it should start with SHAIR Main Dashboard sheet.........fro mattched file i already applied the condition......

Regards,

Anil

Community Browser