topic How to create Inter related or Inter linked Charts in QlikView

How to create Inter related or Inter linked Charts

Mon, 02 Jan 2012 19:43:19 GMT

Dear all,

Please suggest me on this sceniro. I want to create Inter related charts.

I have create a Pie chart with 4 expressions

1. 0 - 3 Months Expression sum(if(trnType='Sales' and days<=90,invTotal))

2. 3 - 6 Months Expression sum(if(trnType='Sales' and days>90 and days<=180,invTotal))

3. 6 - 8 Months Expression sum(if(trnType='Sales' and days>180 and days<=240,invTotal))

4. 8+ Months Expression sum(if(trnType='Sales' and days>240,invTotal))

It working fine.

1. Now I want to create a one more pie chart

2. and one Straight table Chart

related to This First Chart,

suppose when I will click on any IInd slice ( 3 - 6 Months) of first Pie chart then my subsequent IInd Pie chart should show the total Product's sold value for that 3 - 6 Months. slice of First Chart.

In Straight table chart I want to show the Invoice details of select / clicked slice ( 3- 6 Months ) like No, Date, Due On, Customer name etc.

I notice several time that when we click on pie chart's slice pie data change in other charts on sheet.

but at this time there is no action on the sheet.

Please advice me how I can acheive this goal.

Thanks & Regards.

- anil

How to create Inter related or Inter linked Charts

swuehl — Mon, 02 Jan 2012 19:49:24 GMT

I believe the selection in a chart is done on a dimension value, in this example, you are not using a dimension, only four expressions, right? So there will be no selection. In your other pie charts, do you use dimension(s)?

You can create a table containing your four time periods and use this as dimension, then you should be able to select in the charts also. You either need to link this new field to you existing data or check for the dimension value and select the appropriate values in your expressions.

Hope this helps,

Stefan

How to create Inter related or Inter linked Charts

Mon, 02 Jan 2012 20:00:22 GMT

hi, Stefan

Thanks very much for very prompt reply.

Yes, your are right I am not using any dimension, actually I have no need of single dimension suggest me If will take a dimension in this Pie Chart then can hide this dimension because dimension is no worth for me in this case

I am repeating that "can I Hide dimension"

-anil

How to create Inter related or Inter linked Charts

swuehl — Mon, 02 Jan 2012 20:09:07 GMT

In a pie chart, I think there is not much of a visual difference in using a dimension or separate expressions.

In a straight table you can hide the dimension, but then you don't see the dimension values (formerly known as your expression labels, right?) but you can use a pivot table and pivot your dimension to the top, that could look similar to what you currently have (well, I don't know what you currently have, so I am more or less guessing).

How to create Inter related or Inter linked Charts

Mon, 02 Jan 2012 20:30:50 GMT

Thanks Stefan,

After taking care of your suggestions Now it is working fine,

I create a new field Months at the time of load i put all 0-3,3-6,6-8,8+ months in it and this the only single dimension.

it is working fine.

Can you please advice me any document / PDF related to Set analysis and Advance Aggregations for QV 10 / 11

Thanks & Regards.

- anil

How to create Inter related or Inter linked Charts

swuehl — Mon, 02 Jan 2012 20:58:20 GMT

A start may be the manual,

then here are some more sources referenced:

http://community.qlik.com/message/50956#50956

and here is a set expression syntax wizard:

http://www.qlikblog.at/1384/set-analysis-wizard-qlikview/

How to create Inter related or Inter linked Charts

Mon, 02 Jan 2012 21:07:13 GMT

hi, Is it you Stefan WALTHER

Since last one week I am reading this blog post by post, thanks for your both links

thanks again Maestro, headsoff to you.

- anil

How to create Inter related or Inter linked Charts

swuehl — Mon, 02 Jan 2012 21:13:10 GMT

No, I am not Stefan Walther

Stefan's community link:

http://community.qlik.com/people/swr

Have a nice evening,

Stefan