Converting columns into rows

[Anonymous]

I have a table with the following fields

Product      India     US     UK

Fridge          123     111     10

Here, I want to convert the India,US,UK under a single column as Geography and the values as Sales.

Like

Product     Geography     Sales

Fridge          India              123    

Fridge          US                111

Fridge          UK                  10

How can this be done?

[vikasmahajan]

Use Cross Table Functionality

Vikas

[#3]

by using cross table only we solve these issue...

[tresesco]

Try like:

Crosstable( Geography, Sales, 1)

LOAD * Inline [

Product,      India,     US,     UK

Fridge,          123,     111,     10

]

[Anonymous]

Hi, Can you explain the functionality using the above sample data?

[Anonymous]

Hi, Thanks for that.

I'm encountering a problem in my actual data where I have something like

Product     Category     India     US     UK     Sub-Category

So, if I use Cross table here, except Product everything else will be converted to rows. How to solve this problem?

[tresesco · Accepted solution]

Try like:

Crosstable (Geography, Sales, 3)

Load

          Product,

          Category,

          Sub-Category,

          India,

          .....

From <>;

Note : 3 is the number that signifies, first 3 fields would be loaded as it is so it is important to load Sub-Category at the beginning of your load (that is why I mentioned Sub-Category within first three rather that at the last).

[Anonymous]

Thanks a lot tresesco‌. Time and again, you are proving that you are genius when it comes to Qlikview Thanks a lot!