spliting rows into columns using expression

[mohanrajsubrama]

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

[#2]

Hi,

use pivot table.

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

find the attachemnt.

Niranjan M.

[#3]

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

[mohanrajsubrama]

Hi Niranjan,

                Thanks for ur Quick reply.And it worked well.

Regards

mohanraj Subramanian.