topic Re: bug or expected behavior of QV version 12 SR1 in QlikView

bug or expected behavior of QV version 12 SR1

PrashantSangle — Fri, 01 Apr 2016 07:53:47 GMT

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

2: Table Viewer

hic‌‌,

gwassenaar‌

swuehl‌

stevedark‌

Am I missing something or this is expected behavior

Please suggest .

Thanks and Regards,

Prashant Sangle

Re: bug or expected behavior of QV version 12 SR1

arulsettu — Fri, 01 Apr 2016 08:04:59 GMT

i used ur script in my QV 12 i got this

Re: bug or expected behavior of QV version 12 SR1

settu_periasamy — Fri, 01 Apr 2016 08:06:03 GMT

Hi dreamer4‌,

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

Left join broken in QlikView 12 SR1?

Re: bug or expected behavior of QV version 12 SR1

settu_periasamy — Fri, 01 Apr 2016 08:07:30 GMT

Hi Arul,

Try with QV 12 SR1

Re: bug or expected behavior of QV version 12 SR1

t_chetirbok — Fri, 01 Apr 2016 08:10:16 GMT

Hi!

I am using QlikView Version 12.0 and all is good

Re: bug or expected behavior of QV version 12 SR1

jfkinspari — Fri, 01 Apr 2016 08:10:29 GMT

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!

Re: bug or expected behavior of QV version 12 SR1

PrashantSangle — Fri, 01 Apr 2016 08:11:09 GMT

Hi,

thanks for information.

Regards,

Re: bug or expected behavior of QV version 12 SR1

Gysbert_Wassenaar — Fri, 01 Apr 2016 08:26:55 GMT

Can you post the qlikview documents?

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

Re: bug or expected behavior of QV version 12 SR1

Chanty4u — Fri, 01 Apr 2016 08:30:32 GMT

It is with Qv11.2 SR11

Re: bug or expected behavior of QV version 12 SR1

jfkinspari — Fri, 01 Apr 2016 08:40:30 GMT

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.

Re: bug or expected behavior of QV version 12 SR1

awhitfield — Fri, 01 Apr 2016 08:42:51 GMT

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

Re: bug or expected behavior of QV version 12 SR1

sunny_talwar — Fri, 01 Apr 2016 08:46:07 GMT

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

Re: bug or expected behavior of QV version 12 SR1

sunny_talwar — Fri, 01 Apr 2016 08:46:55 GMT

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

Re: bug or expected behavior of QV version 12 SR1

PrashantSangle — Fri, 01 Apr 2016 09:39:28 GMT

Hi,

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

Regards,

Re: bug or expected behavior of QV version 12 SR1

PrashantSangle — Fri, 01 Apr 2016 09:42:23 GMT

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

Re: bug or expected behavior of QV version 12 SR1

swuehl — Fri, 01 Apr 2016 10:42:40 GMT

I think that's the bug mentioned here

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

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.

Re: bug or expected behavior of QV version 12 SR1

PrashantSangle — Fri, 01 Apr 2016 11:04:08 GMT

Thanks.

Re: bug or expected behavior of QV version 12 SR1

swuehl — Fri, 01 Apr 2016 11:34:17 GMT

Just wondering, if anyone noticed an announcement by Qlik?

Seems like a critical bug to me.

Re: bug or expected behavior of QV version 12 SR1

PrashantSangle — Fri, 01 Apr 2016 12:52:38 GMT

Not yet seen any announcement from Qlik

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

Kind Regards,