topic Build qvd with a pivot table in QlikView

Build qvd with a pivot table

Wed, 03 Nov 2010 11:26:48 GMT

Hello,

I have created a pivot table from different source table. I want to build a new source table (qvd) from this pivot table, and add a new empty column?

RGDS.

Build qvd with a pivot table

Wed, 03 Nov 2010 11:43:57 GMT

Hi,

I do it this way:

I run this macro after reaload


sub EXPORT()
 set obj = ActiveDocument.GetSheetObject("CH01")
 obj.ExportEx "C:\NewSource.qvd", 4
end sub

CH01: PivotTable ID
Now I don't remember which parameter is "4", but you can find in the APIGuide...

Build qvd with a pivot table

Wed, 03 Nov 2010 11:47:02 GMT

sorry! do not understand what you mean with: "and add a new empty column". Why you need to?

Build qvd with a pivot table

Wed, 03 Nov 2010 11:59:28 GMT

Thx very much 🙂

Rgds

Build qvd with a pivot table

Wed, 03 Nov 2010 12:04:50 GMT

i would to add a new col on my pivot table, this col doesn't exist in my source table, i had used inline load table, it work thx

Build qvd with a pivot table

Wed, 03 Nov 2010 12:07:31 GMT

But i have another problem!

I calcul in my pivot table sum of turn over by proudct for every company. i want to add a new colomun wich contain the name of the company with the max turn over.

Build qvd with a pivot table

Wed, 03 Nov 2010 16:51:31 GMT

I do not know if I understood everything right. My English is bad!

you get the data (IdCompany, Sales, ...) from the corresponding source (SQL, XLS). Then, do you want to add the name of the company?

if so, use "join" or "left join" or ... to add the names from another source (inLine, xls, ...)


Table1:
LOAD
 CompanyID,
 Product,
 .
 .
 .
 sum(Sales)
FROM .....
GROUP BY .....;
left join (Table1)
LOAD
 CompanyID,
 CompanyName
FROM .....;

Build qvd with a pivot table

Wed, 03 Nov 2010 17:05:47 GMT

No! I have this pivot table

Product	Sum turn over
P1	40

For P1: Sum turn over = turn over(company1) + turn over(company2) + turn over(company3)

10 + 20 + 10

I want in my pivot table add column ' Best turn over company' which contain the name of company with max turn over, in my example: company2

New pivot table:

Product	Sum turn over	Best turn over company'
P1	40	company2

Build qvd with a pivot table

sebastiandperei — Wed, 14 Mar 2012 18:49:57 GMT

Hi,

Add this new expression:

=If (Turn_Over_Comp1 > Turn_Over_comp2 and Turn_Over_Comp1 > Turn_Over_comp3, 'Company 1',

If (Turn_Over_Comp2 > Turn_Over_comp1 and Turn_Over_Comp2 > Turn_Over_comp3, 'Company 2' , 'Company 3'))

Build qvd with a pivot table

sebastiandperei — Tue, 20 Mar 2012 16:07:29 GMT

This was useful for you?