Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
PrashantSangle

bug or expected behavior of QV version 12 SR1

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

  • Frequency of val became 3 (which is expected)
  • Output of Sum(Val) is 330 (expected)
  • Screen shot
    • Capture1.PNG

Table Viewer

Capture.PNG

2: QlikView Version 12.0 SR1

  • Frequency of val still remain 1 (which is not expected).
  • Output of Sum(Val) still 110 (not expected)
  • In short the join operation not performed in version 12
  • Screen shot

1:

Capture2.PNG

2: Table Viewer

Capture3.PNG         

hic‌‌,

gwassenaar

swuehl

stevedark

Am I missing something or this is expected behavior

Please suggest .

Thanks and Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
18 Replies
arulsettu
Master III
Master III

i used ur script in my QV 12 i got this

Untitled.png

settu_periasamy
Master III
Master III

Hi dreamer4‌,

I think, there are some discussion regarding the Left join issue in QV 12 SR1.

Left join broken in QlikView 12 SR1?

settu_periasamy
Master III
Master III

Hi Arul,

Try with QV 12 SR1

t_chetirbok
Creator III
Creator III

Hi!

I am using QlikView Version 12.0 and all is good

jfkinspari
Partner - Specialist
Partner - Specialist

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!

PrashantSangle
Author

Hi,

thanks for information.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Gysbert_Wassenaar

Can you post the qlikview documents?

Does this also happen if you reload the document created with QV 11 in QV 12?


talk is cheap, supply exceeds demand
Chanty4u
MVP
MVP

It is with Qv11.2 SR11

DM.PNGDm-2.PNG

jfkinspari
Partner - Specialist
Partner - Specialist

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.