topic Re: Help needed on Trigger. Urgent in QlikView

Help needed on Trigger. Urgent

Tue, 10 Jul 2012 08:52:04 GMT

Hi all,

I have a field name " User Name " which is displayed in Pie chart as well as Table, now I want that when I click on a particular name in " User Name" i should land on other sheet but this trigger shouldn't be in Pie chart.

Plz help me solve this issue and i badly need the solution.

Regards

Sagar Gupta

Re: Help needed on Trigger. Urgent

jagan — Tue, 10 Jul 2012 09:06:44 GMT

Hi,

Try

Document Properties -> Triggers -> Field Event Triggers -> OnChange or OnSelect (Events)

Regards,

Jagan.

Re: Help needed on Trigger. Urgent

magavi_framsteg — Tue, 10 Jul 2012 09:14:40 GMT

Hi Sagar.

You can create a FieldEventTrigger.OnSelect in Document properties > Triggers.

So whenever the field [User Name] is selected, you switch sheet by using an action to do that.

Please see attached document.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Help needed on Trigger. Urgent

Tue, 10 Jul 2012 09:23:08 GMT

Hi Jagan,

Thanks for the reply, but i guess u didn't understand my problem.

M trying to explain again below:

I have two feild names( User_Name and Region) which i m displaying in double pie chart, also i have a table which is driven by this pie chart.

now when i click User_Name i see different Regions in the table for which that User is responsible for and when i click Region i see different User_Name in the table who falls in that particular Region.

What i require....

If i click on a particular User in table i should be able to land on sheet X and when i click on particular Region in table i should be able to land on sheet Y.

Note: The trigger should not functional in the pie chart.

Re: Help needed on Trigger. Urgent

magavi_framsteg — Tue, 10 Jul 2012 09:34:48 GMT

Hi Sagar.

Please see my attached doc.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Help needed on Trigger. Urgent

Tue, 10 Jul 2012 10:58:36 GMT

Hi Magnus,

Thanks for reply

I checked your QVW file but its not the one i want, here your pie chart seems to be detached.

I want my pie chart to be functional but it should not take me to other sheet, whereas i want my table to take me to the respected sheet.

Regards

Sagar Gupta

Re: Help needed on Trigger. Urgent

Wed, 11 Jul 2012 06:08:19 GMT

Hi Magnus,

Thanks for reply

I checked your QVW file but its not the one i want, here your pie chart seems to be detached.

I want my pie chart to be functional but it should not take me to other sheet, whereas i want my table to take me to the respected sheet.

Regards

Sagar Gupta

Re: Help needed on Trigger. Urgent

magavi_framsteg — Wed, 11 Jul 2012 07:43:15 GMT

Maybe you could add duplicate fields.

And have the pie use one field, and the table use the other field.

And trigger the field that's used on the table.

Will that work for you?

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: Help needed on Trigger. Urgent

Wed, 11 Jul 2012 07:51:31 GMT

Thanks for reply,

Ya I could do this but the problem with me is that I already have truck load of data, n m suffering from it.

Plz let me know if there is any other way other than macro and duplicating the fields.

Regards

Sagar Gupta

Re: Help needed on Trigger. Urgent

magavi_framsteg — Wed, 11 Jul 2012 08:10:47 GMT

Hi again Sagar.

My experience has shown me that it is often a good approach to keep the documents as standardized as possible. It makes fewer and easier maintenance and development.

Meaning for example, but not limited to:

- Clickable charts

- Centralized expressions

- No or little macro code

- Few set analysis so what you see in charts correspond to your current selections

- No or few hidden objects

- Optimized data model with correct data types, ie. always try and use int/date before strings

- Star schemes, not relational schemes

- If many dimensions, try instead joining them to the fact table making the fact table wider

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.