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: 
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
jagan
Luminary Alumni
Luminary Alumni

Hi,

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

I added one more action to selest the field.

Regards,

Jagan.

View solution in original post

14 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Settings > Document Properties > Triggers

Set a Layout > Activate Sheet action OnOpen.

Hope this helps,

Jason

jagan
Luminary Alumni
Luminary Alumni

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
Author

   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_Michaelides
Luminary Alumni
Luminary Alumni

Can you post your app?

jagan
Luminary Alumni
Luminary Alumni

Hi Anil,

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

Regards,

Jagan.

Not applicable
Author

  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_Michaelides
Luminary Alumni
Luminary Alumni

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

kuba_michalik
Partner - Specialist
Partner - Specialist

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
Author

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