Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
DipeshVadgama
Contributor

Ratio Contribution

Hi All,

Below it data,

   

Country
India
Japan
China
India
India
Japan
China
India
India
Japan
China
USA
India
China
China
USA
India
Japan
China
USA
India
USA
USA

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

   

Country       %
India26.1%
Japan34.8%
China17.4%
USA21.7%
1 Solution

Accepted Solutions
micheledenardi
Valued Contributor

Re: Ratio Contribution

see attached file.

4 Replies
micheledenardi
Valued Contributor

Re: Ratio Contribution

see attached file.

DipeshVadgama
Contributor

Re: Ratio Contribution

Hi Michele,

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

micheledenardi
Valued Contributor

Re: Ratio Contribution

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;

DipeshVadgama
Contributor

Re: Ratio Contribution

Thanks Michele

Community Browser