Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mohanrajsubrama
New Contributor II

spliting rows into columns using expression

Hi Guys ,

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

countrygendercount (arrivals)
india male200
india female200
albania male45
albania female50
algeriamale25
algeriafemale75

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

countrymale femaletotal numbers
india200200400
albania455095
algeria2575100

               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

Tags (1)
3 Replies
Not applicable

Re: spliting rows into columns using expression

Hi,

use pivot table.

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

find the attachemnt.

Niranjan M.

Not applicable

Re: spliting rows into columns using expression

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
New Contributor II

Re: spliting rows into columns using expression

Hi Niranjan,

                Thanks for ur Quick reply.And it worked well.

Regards

mohanraj Subramanian.

Community Browser