creating 100% grouped bar per country

[Anonymous]

Hi guys,

I have a bar chart that give the percentage of shipments that are ontime or late per country.

the bar chart calculates the percentage of ontime/late based on all the countrycodes in the bar chart. Only when I click on a certain country e.g. 'AE' I see the the 'total percentage' of a specific country.

Is there a way to do this for all the country, without having to click on a certain country?

I have 2 dimensions:

CountryCode

Status

My expression is: count(shipmentid) / count(Total shipmentid)

Thanks in advance!

Isam

I've attached a screenshot with what I'm trying to achieve.

Regards,

iSam

[Sokkorn]

Hi iSam,

Can you attached a small application? So that it can easy to solve your issue.

Regards,

Sokkorn Cheav

[Anonymous]

Hi,

I've attached a sample of my qlikview document.

Regards,

Isam

[Sokkorn]

Hi ISam,

I will reply you back by tomorrow. Coz I need to go now.

Regards,

Sokkorn Cheav

[Anonymous]

Thanks looking forward for your reply J

[#6 · Accepted solution]

Hi iSam, you can use count(Order) / count(Total <Ctry> Order) to get the 100% bar per country

[Anonymous]

Hi Sajeevan,

That indeed did the job! Thanks for your help!!

iSam

[#8]

Thanks, please mark the posting as answered

[Sokkorn]

Hi iSam,

Here is the second solution

Create <Bar Chart> with

1. Ctry as Dimentions

2. Two Expression

    . COUNT({$<Status = {'Late'}>} Order) / count(Order)          with Label <Late>

    . COUNT({$<Status = {'OnTime'}>} Order) / count(Order)     with Label <OnTime>

See the attached file also.

Regards,

Sokkorn Cheav

[Anonymous]

Hi Sokkorn,

Thanks for sharing your solution!!

Regards,

iSam