3 Replies Latest reply: Dec 21, 2012 4:41 AM by Mohanraj Subramanian RSS

    spliting rows into columns using expression

    Mohanraj Subramanian

      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

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

      countrymale femaletotal numbers

                     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