Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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
MVP & Luminary
MVP & Luminary

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_michaelid
Luminary
Luminary

Settings > Document Properties > Triggers

Set a Layout > Activate Sheet action OnOpen.

Hope this helps,

Jason

jagan
MVP & Luminary
MVP & Luminary

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

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

Can you post your app?

jagan
MVP & Luminary
MVP & Luminary

Hi Anil,

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

Regards,

Jagan.

Not applicable

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

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

kuba_michalik
Partner
Partner

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

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