Discussion Board for collaboration related to QlikView App Development.
I'm doing the following question.
Left Join (Table1)
Field4 as Field 99
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.
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?
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)