topic Re: spliting rows into columns using expression in QlikView

spliting rows into columns using expression

mohanrajsubrama — Fri, 21 Dec 2012 08:24:49 GMT

Hi Guys ,

I have a column countryname,gender,and total count .when i bring this in qlikview table it comes like this.

country	gender	count (arrivals)
india	male	200
india	female	200
albania	male	45
albania	female	50
algeria	male	25
algeria	female	75

Actually i want my data to be in qlikview table as per client requirement in this format.

country	male	female	total numbers
india	200	200	400
albania	45	50	95
algeria	25	75	100

how do i get this .As far now Country and gender is in dimension and count(Arrivals) is in expressions.How can i get this using expression .Can you guys help.

mohanraj subramanian

Re: spliting rows into columns using expression

Fri, 21 Dec 2012 08:53:50 GMT

Hi,

use pivot table.

in that you can drag and set dimension as column as row header.

find the attachemnt.

Niranjan M.

Re: spliting rows into columns using expression

Fri, 21 Dec 2012 09:04:59 GMT

Hi,

If you want always de same number of columns you could use Set Analysis y a chart too.

Dimension: Country

Expresions: male --> =count({<gender = {"male"}>} arrivals)

female --> =count({<gender = {"female"}>} arrivals)

total --> =count(arrivals)

This way you will always have the columns "male" and "female" even you haven't data of any of them.

Jairo

Re: spliting rows into columns using expression

mohanrajsubrama — Fri, 21 Dec 2012 09:41:44 GMT

Hi Niranjan,

Thanks for ur Quick reply.And it worked well.

Regards

mohanraj Subramanian.