topic Re: setting a constant size for dimensions in mekko charts in QlikView

setting a constant size for dimensions in mekko charts

arixooo123 — Wed, 17 Sep 2014 06:08:00 GMT

Hello Dears,

I like to see to status of customers in 33 countries, mekko charts do that nicely, the problem is that size bars are proportional to the number of customers in each country, that makes a country like china or India to get most of the screen and little part to others. that makes it hard to view and understand.

is it possible to change the setting of a mekko chart in a way that assign a constant space to each value (in this case country).

Thanks Guys

Re: setting a constant size for dimensions in mekko charts

jagan — Wed, 17 Sep 2014 06:17:08 GMT

Hi,

If you want the same width for all the bars then use Bar chart instead of Mekko chart.

Regards,

Jagan.

Re: setting a constant size for dimensions in mekko charts

tresB — Wed, 17 Sep 2014 06:17:50 GMT

Bar Chart?

Re: setting a constant size for dimensions in mekko charts

arixooo123 — Wed, 17 Sep 2014 06:23:33 GMT

Then how to see the status of customers in bar chart? You see in my data set, each customer can have a status of Active, Passive, Good, Bad i like to see the percentage of each segment in each country. mekko does that, but it has the mentioned problem. i don't know if i can show that in a bar chart. if yes, would you please explain to me how?

thanks buddy

Re: setting a constant size for dimensions in mekko charts

arixooo123 — Wed, 17 Sep 2014 06:32:31 GMT

thanks buddy

Re: setting a constant size for dimensions in mekko charts

jagan — Wed, 17 Sep 2014 06:34:34 GMT

Hi,

Try using Stacked bar chart

Chart Properties -> Style -> Select Stacked

Regards,

Jagan.

Re: setting a constant size for dimensions in mekko charts

arixooo123 — Wed, 17 Sep 2014 06:41:21 GMT

i don't know how stacked chart can solve my problem. I changed the Chart to Stacked but know just one of the dimensions is been accounted. the first one (Country) and the second one which is Customer Status doesn't appear in the chart. the interesting part is that stacked is also proportional to the size of each value, countries with more customers have more space.

Re: setting a constant size for dimensions in mekko charts

jagan — Wed, 17 Sep 2014 06:51:54 GMT

Hi,

Can you attach sample file with your mekko chart?

REgards,

Jagan.

Re: setting a constant size for dimensions in mekko charts

arixooo123 — Wed, 17 Sep 2014 07:06:01 GMT

sorry buddy, i did not know how to export a sample from my data, although i think it's easier to understand, because i simplified the question and the real data is not like this. nevertheless, here is what i have and what i want. in my data set, i have customers who have status and country, i added them as dimensions and set the expressions as COUNT(CUSTOMERS).

thanks

Re: Re: setting a constant size for dimensions in mekko charts

jagan — Wed, 17 Sep 2014 07:09:24 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: setting a constant size for dimensions in mekko charts

arixooo123 — Wed, 17 Sep 2014 07:13:40 GMT

Thanks buddy, that's what i want

Re: setting a constant size for dimensions in mekko charts

arixooo123 — Wed, 17 Sep 2014 07:28:42 GMT

sorry, but now i have a issue. the problem with width of bars shifted to the height of them. countries with less customers are that short which is not even readable. in order to see the percentage instead of number, i set the expression as count([customers])/count( total [customers])

i like to see each country regardless of its customer numbers equal in size. the thing i'm looking for is the percentage of each customer status segment in each country.

for example 40% of india customers are active, in china 45% are active. information like this should be easily readable from this chart.