topic Re: Help with Graphs in QlikView

Help with Graphs

Tue, 23 Aug 2011 10:10:16 GMT

Hi,

I have a requirement to automatically filter data when double clicks on a particular item in graph.

I have two graphs created. One graph shows data for 'Group 1' and second graph for 'Group 2'. But when I make a selection in graph 1 it should automatically filter data for 'Group 1'.

In the attached document when I double click on year 2001, the data in the below table should show only 'Group 1' data. But it is showing both 'Group 1' and 'Group 2' data.

Please help me with this.

Regards,

Murali

Help with Graphs

SunilChauhan — Tue, 23 Aug 2011 11:31:24 GMT

here you have data for both group1 and group2 in 2001 thats why in below table show for both group

please check ur data

Help with Graphs

kaushiknsolanki — Tue, 23 Aug 2011 11:45:20 GMT

Hi,

It is because you have used textbox to display the data.

So when you select 2011, you have two possible values i.e Group1 and Group2 and thus it shows both.

Now if you want to show only the data from Group1 and Group2 respectively, then you should use the straight table with the same expression which you used in bar chart. (Note a seperate Straight table for both Group1 and Group2)

Regards,

Kaushik Solanki

Help with Graphs

Tue, 23 Aug 2011 12:54:33 GMT

Thanks Kaushik for your response.

But the business requirement is to have graphs.

Because first graphs shows the data for 'Group1' and when user double clicks on 2001 bar, user wants to filter data for 2001 as well as 'Group1'. I know this is not the default QlikView functionality. But client wants this.

Is there any event that gets fired when a selection is made in graph? Or is there any other way to achieve this?

Regards,

Murali

Re: Help with Graphs

sridhar240784 — Tue, 23 Aug 2011 13:25:12 GMT

Hi Murali,

As far as i understood from this discussion, you may achieve this by creating two fields in backend for year. lets say one field for Group1 and Another field for Group 2, like below.

Year(Transaction_Date) as Year_Group1, //This field you can use in Chart1 i.e. Group 1 chart

Year(Transaction_Date) as Year_Group2, //This field you can use in Chart2 i.e. Group 2 chart

Year(Transaction_Date) as Year, // This field is for general selections in your dashboard.

Now Create your 1st chart i.e. Group1 chart with Year_Group1 dimension and Create your 2nd chart i.e. Group2chart with Year_Group2 dimension.

Create 2 pivot table, one with Group1 filter and one with Group 2 filter.

Now use GetSelectedCount() function to hide and unhide this pivot tables using Conditional Show option.

your condition should look like below to activate the 1st group pivot table is

GetSelectedCount(Year_Group1)>=1

Your condition to activate 2nd group pivot table should be as follows

GetSelectedCount(Year_Group2)>=1

Hope i`m clear and hope this helps you.

-Sridhar

Re: Help with Graphs

Tue, 23 Aug 2011 13:54:16 GMT

Sridhar,

Thanks for your response. Very userful one.

What user wants is.

When he click on 2001 bar in first chat, it will add 'Year = 2011' to the current selection. At the same time user want 'Group=Group1' to be added to current selection.

I hope I am now clear with my requirement. and apologies for any confusion with the description in my original post.

Regards,

Murali

Re: Help with Graphs

sridhar240784 — Tue, 23 Aug 2011 14:26:25 GMT

ok, check out the attached application.

As i said earlier, Create 2 field for 2 Groups like Year_Group1 and Year_Group2. Use this 2 fields in your Report.

Create one Dummy field with field name 'Group' and Field info as Group1 and Group2.

Now we can use the "Field Event Trigger" to trigger an action when user select something from the field using "select in Field" action which you can find in Document Property.

Check the attached application.

Hope this helps you.

-Sridhar

Re: Help with Graphs

Tue, 23 Aug 2011 15:11:03 GMT

Thanks Sridhar.

This is what I am looking for. This trigger will help me to achieve my requirement.

Thanks once again for your help.

Re: Help with Graphs

Wed, 24 Aug 2011 10:10:32 GMT

Sridhar,

Will this trigger work when I view the dashboard via Ajax Zero foot print client on IE8?

Regards,

Murali

Re: Help with Graphs

sridhar240784 — Wed, 24 Aug 2011 13:08:04 GMT

Murali,

This trigger should work but i have not tested it my self. Please try testing it.

-Sridhar