Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
brunopaulo
Partner
Partner

Correction Left Join

Hello community,

I'm doing the following question.

Table1:

Load

     Field1,

     Field2,

     Field3,

     Value

From File;

Left Join (Table1)

Load

     //keys

     Field 1,

     Field 2,

     Field3,

    

// dimensions

     Field4 as Field 99

From File;

Now my problem is when i get a pivot table with

Field 1, Field2, Field,3 and Field99 my value is replicate by the number of times i get field99.

Example

i have 4 times field99 the value i get is Value*4. And i only want 1 time this Value. 

What im looking value only.

I'm trying solve in script anyone has ideas how to do it?

Best Regards

Bruno Paulo

1 Reply
boorgura
Specialist
Specialist

How do you want the Value to be split against Field99's 4 values.

Lets say the record is

F1, F2, F3, 100

And second table has

F1, F2, F3, x1

F1, F2, F3, x2

F1, F2, F3, x3

F1, F2, F3, x4


as the rows.


Obviously when you do a left join you will see 100 in all 4 rows.

If that's not what you want to see - how do you intend to pivot the 100 against Field99 (meaning what should be split of 100 for x1, x2, x3 and x4)