topic Re: Triggers in QlikView

Triggers

h_prakash — Wed, 27 May 2015 19:28:22 GMT

Hi ,

I have a dashboard with three sheets(A, B, C) and I have a Filter which is same across all the sheets. So if I select a options from that filter the metrics will change according to the selected filter across all the sheets. I got a requirement where if I opened a dashboard first sheet A needs to be seen with a selected filter.

For Example Three Sheets = A, B, C Filter has = Company, Sales, Output Requirement = A sheet need to shown with Sales as filter selected when you open a dashboard.

Thanks

Nag

Re: Triggers

Qrishna — Wed, 27 May 2015 20:21:55 GMT

Please see attached doc.

let me know if you have any questions.

Hope that helps.

Re: Triggers

Qrishna — Wed, 27 May 2015 20:47:54 GMT

Please mark it answered If you that helped you in resolving your problem.

Thanks

Re: Triggers

h_prakash — Wed, 27 May 2015 20:53:11 GMT

Hi Chaithanya,

Thanks for your response. But I have three sheets. A, B, C. So every time you open the dashboard A sheet should come up and selected filter.like sales in the above example.

Is what you are trying to explain..?

Thanks

Nag

Re: Triggers

Qrishna — Wed, 27 May 2015 20:56:05 GMT

Exactly.

I have demonstrated in the attached QVW.

On Open - it opens the sheet A with 'Sales' selection in the filter.

when you click on other filers, respective sheets will be opened.

let me know if you want all the sheets to be visible after opening but On Open you want to see Sheet A with 'Sales' selection in the filter?

please check

Re: Triggers

h_prakash — Wed, 27 May 2015 21:12:07 GMT

Hi Chaithany I want to see all the sheets. Can you please help me in this regard.

Thanks

Re: Triggers

h_prakash — Wed, 27 May 2015 21:13:01 GMT

And can you plz also include the steps what you have done. Thanks in Advance.

Re: Triggers

Qrishna — Wed, 27 May 2015 21:15:50 GMT

If you want to see all the sheets, then why are you using the filters?

Please explain in detail so that i can suggest a better solution.

Thanks

Re: Triggers

h_prakash — Wed, 27 May 2015 21:35:26 GMT

Please find the screen shot below for ur reference. Oveview, Details and Data Tables are the three sheets. Years, Thearpeutic Area, Indication and Phase are Filters. (Sorry I forgot to tell you these filters are Straight tables without expressions). So in Phase I have three 3 options. Phase 1, Phase 2, Phase 3. Right now in the filter all the phases are getting selected when I open the dashboard. But I should see the Overview sheet with Phase 2 data (That means phase 2 should be selected from the above filter.)

Note : I should see all the sheets just like in the picture.

Please let me know if I am not clear.

Re: Triggers

ankit777 — Thu, 28 May 2015 04:52:56 GMT

Follow these steps

1. Open your overview sheet

2. goto properties

3.goto triggers

4. Click add action on activate sheet

5. Add action- Selection- select in field

6. Mention field as Phase and search string as phase 2

this will select phase 2 in overview sheet when you open it.

If you want to clear the selection on leaving the sheet, add another trigger same way on leave sheet and clear field.

Ankit

Re: Triggers

MayilVahanan — Thu, 28 May 2015 06:11:50 GMT

Try like this

1. Open document properties

2. Goto triggers tab

3. Document Event Triggers -> OnOpen -> Click add action

5. Add action-> Selection-> select in field

6. Mention field as Phase and search string as phase 2

7.Add action-> Active Sheet -> Give the overview sheet ID.

8. Click ok.

So whenever dashboard open, it select the Phase 2 value in Phase field and open the overviwe sheet,

Hope it helps

Re: Triggers

Qrishna — Thu, 28 May 2015 15:22:58 GMT

Please see attached.

Hope this will solve your problem.

Re: Triggers

h_prakash — Thu, 28 May 2015 16:01:01 GMT

Problem Solved..Thank you All..