topic Re: Converting columns into rows in QlikView

Converting columns into rows

Anonymous — Tue, 06 Oct 2015 04:42:44 GMT

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.

Product Geography Sales

Fridge India 123

Fridge US 111

Fridge UK 10

How can this be done?

Re: Converting columns into rows

vikasmahajan — Tue, 06 Oct 2015 04:55:16 GMT

Use Cross Table Functionality

Vikas

Re: Converting columns into rows

Tue, 06 Oct 2015 04:55:46 GMT

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

Re: Converting columns into rows

tresB — Tue, 06 Oct 2015 04:56:15 GMT

Try like:

Crosstable( Geography, Sales, 1)

LOAD * Inline [

Product, India, US, UK

Fridge, 123, 111, 10

]

Re: Converting columns into rows

Anonymous — Tue, 06 Oct 2015 04:56:18 GMT

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

Re: Converting columns into rows

Anonymous — Tue, 06 Oct 2015 05:00:35 GMT

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?

Re: Converting columns into rows

tresB — Tue, 06 Oct 2015 05:05:50 GMT

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).

Re: Converting columns into rows

Anonymous — Tue, 06 Oct 2015 05:12:05 GMT

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