topic Re: pivot table ? in QlikView

pivot table ?

Anonymous — Sun, 02 Sep 2012 09:53:25 GMT

Hi ,

I'm newer and I'm trying to build a table like this:

Sales Sales Sales

Customer Product type1 ProductType2 ProductType3 Totale Sales

A 1000 500 300 1800

B 2000 - 500 2500

C 3000 1000 4000 8000

....

I've three product types and I need to list allo the values in the same line, practically one line for each product

How can I realize this kind of table

I'm working with the QLIK PERSONAL EDITION

Help please!

Thanks in advance

Gr.

Re: pivot table ?

Anonymous — Sun, 02 Sep 2012 10:23:40 GMT

Hi, you can use a straight table. Customer as dimension, for each Product type one expression and for totals you can use a fourth expression being column(1)+column(2)+column(3). Regards, Sander

Re: pivot table ?

Anonymous — Sun, 02 Sep 2012 14:48:46 GMT

First of all, thanks for your answer.

I'm sorry, I must be more clear about this issue.

Previously, I wrote "three" Producttype, but really I don't have a fixed number. The product type column number is random, it depending on sales distribution.

Practically, I don't know which Product type will be loaded

Hope this is more clear

Thanks

Bibo

Re: pivot table ?

sebastiandperei — Sun, 02 Sep 2012 15:02:32 GMT

Hi bibopipo!

Welcome to qlikview world!!

1) make a Pivot Table

2) Customer as first dimention

3) Product as second dimention

4) Sum(Sales) as Expression

5) Go to Presentation. In Dimentions and Expressions (upper left corner) you will see all the dimentions and expressions you have. When you select one dimention, you can click on "Show partial sums". In your case, if you want to get the total of each customer, click the "Show partial sums" for the Product dimention. If you want to see the total for each Product too, click on the same for Customer.

6) click ok Ok for make the table

7) click on the Product column field, and drop it to the left, until the blue flag cames horizontal.

😎 enjoy you table!!

I recomend that you "play" with the options, for understanding them.

Re: pivot table ?

Anonymous — Sun, 02 Sep 2012 15:50:59 GMT

Thanks very much !!!