Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
use pivot table.
in that you can drag and set dimension as column as row header.
find the attachemnt.
Niranjan M.
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
Hi Niranjan,
Thanks for ur Quick reply.And it worked well.
Regards
mohanraj Subramanian.