Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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.
Tags (1)
18 Replies
arulsettu
Honored Contributor III

Re: bug or expected behavior of QV version 12 SR1

i used ur script in my QV 12 i got this

Untitled.png

Re: bug or expected behavior of QV version 12 SR1

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

Hi Arul,

Try with QV 12 SR1

t_chetirbok
Valued Contributor

Re: bug or expected behavior of QV version 12 SR1

Hi!

I am using QlikView Version 12.0 and all is good

Partner
Partner

Re: bug or expected behavior of QV version 12 SR1

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

Hi,

thanks for information.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
MVP & Luminary
MVP & Luminary

Re: bug or expected behavior of QV version 12 SR1

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
Esteemed Contributor III

Re: bug or expected behavior of QV version 12 SR1

It is with Qv11.2 SR11

DM.PNGDm-2.PNG

Partner
Partner

Re: bug or expected behavior of QV version 12 SR1

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.