Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
This is my first application in QlikView Version 12 SR1
I have got one interesting behavior when I ran same code in 2 different version of qlikview on 2 different machines.
i. e. between Qlikview Version 11.20 SR7 and QlikView Version 12.0 SR1
and found that my join is not working as expected.
My Test Code (Code copied from thread Auto table totals inconsistent with data model of david.maurice ) :
Test:
LOAD * INLINE [
customerID, Cust_type, cust_val
4, 1, 40
4, 2, 30
4, 3, 40
] ;
Left Join
LOAD * INLINE [
customerID, val
4, 110
];
When I ran above code in
1: Qlikview Version 11.20 SR7
Table Viewer
2: QlikView Version 12.0 SR1
1:
2: Table Viewer
hic,
Am I missing something or this is expected behavior
Please suggest .
Thanks and Regards,
Prashant Sangle
i used ur script in my QV 12 i got this
Hi dreamer4,
I think, there are some discussion regarding the Left join issue in QV 12 SR1.
Hi Arul,
Try with QV 12 SR1
Hi!
I am using QlikView Version 12.0 and all is good
Hi Max,
I get the same results as you, and I can conclude it also effects INNER JOIN, where only 1 line remains after script execution. It really seems like it's a nasty bug!
Hi,
thanks for information.
Regards,
Can you post the qlikview documents?
Does this also happen if you reload the document created with QV 11 in QV 12?
It is with Qv11.2 SR11
The behaviour depends solely on the executing QlikView version.
A document created with 11.2 runs with expected results when executed using 11.2, but only joins first row when using version 12 SR1.