topic Ratio Contribution in QlikView

Ratio Contribution

DipeshVadgama — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Below it data,

Country

India

Japan

China

India

Japan

China

India

Japan

China

USA

India

China

USA

India

Japan

China

USA

India

USA

I am trying to find out ration of each country with total country while loading script, below example

Country	%
India	26.1%
Japan	34.8%
China	17.4%
USA	21.7%

Re: Ratio Contribution

micheledenardi — Mon, 29 May 2017 12:12:46 GMT

see attached file.

Re: Ratio Contribution

DipeshVadgama — Mon, 29 May 2017 12:42:47 GMT

Hi Michele,

Sorry but I can't open this file. Can please paste script here, thanks 🙂

Re: Ratio Contribution

micheledenardi — Mon, 29 May 2017 12:56:01 GMT

Country_tmp:

LOAD

Country

FROM [Country.xlsx]

(ooxml, embedded labels, table is Foglio1);

Country:

NoConcatenate

Load

Country,

num(count(Country)/NoOfRows('Country_tmp'),'#.##0,0%') as percentage

Resident Country_tmp Group by Country;

drop Table Country_tmp;

Re: Ratio Contribution

DipeshVadgama — Mon, 29 May 2017 13:49:57 GMT

Thanks Michele