bug or expected behavior of QV version 12 SR1

[PrashantSangle]

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
  • 

Table Viewer

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:

2: Table Viewer

         

hic‌‌,

gwassenaar‌

swuehl‌

stevedark‌

Am I missing something or this is expected behavior

Please suggest .

Thanks and Regards,

Prashant Sangle

[awhitfield]

Just upgrade from v12 to v12 SR1, created the above and can confirm it's ok in 12 but NOT in SR1

Looks like a bug!

Andy

[sunny_talwar]

Gysbert - It did happen to me for a document created in QV 11.20 (not sure which SR)

[sunny_talwar]

Personally for me QV 12 worked fine. I saw the issue in SR1 and then revert back to QV12.

[PrashantSangle]

Hi,

not just inner join, all joins not working as expected to work.

Regards,

[PrashantSangle]

Hi,

PFA file developed using QV versions 11 sr7.

Yes I have checked that if file is created in version 11 and reloaded in version 12 sr1

my Output was changed

Regards

[swuehl]

I think that's the bug mentioned here

https://community.qlik.com/blogs/technicalbulletin/2016/03/14/qlikview-1200-sr1-now-available#commen...

and in discussed in some recent threads.

Christian already created a bug report that was confirmed by Qlik. They seem to be working on a patch.

[PrashantSangle]

Thanks.

[swuehl]

Just wondering, if anyone noticed an announcement by Qlik?

Seems like a critical bug to me.

[PrashantSangle]

Not yet seen any announcement from Qlik

And yes It is a critical bug, It is making huge impact on final result.

Kind Regards,