topic Chart grouped by percent in QlikView

Chart grouped by percent

Fri, 06 Jan 2012 17:21:29 GMT

Hello,

I´ve this below chart on Excel.

How can i do this on qlikview? I need to group values on chart always based on 100%

What kind of chart i need to chose?

Thank you!

rrsrini2907 — Fri, 06 Jan 2012 17:32:09 GMT

Hi,

I think this chart has two dimensions,

1. Country

2. Dark Green (Is Insured) / Light Green (Not Insured) [ For Example ]

The chart represents how many % of people are insured across different country.

So, based on above assumptions:

Try metric like this

Count(People)/Count(Total <Country> People)

Something like this. This will calculate People for respective dimension and group by Country.

Regards,

Srini.

Fri, 06 Jan 2012 17:33:59 GMT

Hi Srinivas,

Do you have any example?

Thank you

rrsrini2907 — Fri, 06 Jan 2012 17:44:08 GMT

If you have sample file, post it.

I will create that chart.

Since i dont have sample with me now, i cannot post it.

Regards,

Srini.