topic Associate Tables with Charts in QlikView

Associate Tables with Charts

Thu, 07 Jun 2012 01:21:54 GMT

Dear members,

I request your ideas on how I can achieve the following.

- I have 2 Charts and 2 Tables. The first chart is Top 10 Cities by Revenue. The second chart is bottom 10 Cities by Revenue.

- The first table is Cities and Revenues sorted in Decending order by Revenue. The second table is Cities and Revenues sorted by Revenue in Ascending order by revenue.

Basically my ideas is that if a users wants the graph he will have the chart. If we want details, he can see the table below. (However, since Table 1 and Table 2 are same but with different sort order, they are all interconnected. )

Header 1	Header 2
CHART1	CHART2
TABLE1	TABLE2

If user clicks on a City in Chart1 it is chaning rest of all 3 components. I want the City selection in Chart1 to impact only Table 1. Similarly anything selected in Chart 2 should only impact Table 2. How can I do it. Detach option on all components is not working as expected.

Thank you.

Associate Tables with Charts

rwunderlich — Thu, 07 Jun 2012 02:59:32 GMT

Are you using QV11? If so, you can use the Alternate States feature.

-Rob

Associate Tables with Charts

Thu, 07 Jun 2012 03:06:26 GMT

Thanks Rob,

I am not on QV 11 Yet. And second issue is, I am still on the first rung of QV ladder. I have to research on Alternate Features.

I implemented a different approach. I am using one table with Rank function. Two charts, one for top 10 and the other for bottom 10. I detached the table. That way, they can see top 10, bottom 10 and if they want all, they can see fully expanded table sorted by rank.

Regards.