Discussion Board for collaboration related to QlikView App Development.
Can someone please explain why in QV11 I get one row in my resulting table, but in QV12 I get two with this script:
LOAD * INLINE [
2000,March Financial Year
In SQL and QV11 both a left join and inner join would return two rows.
Left or Right keep join will return two rows but only one row will have the calendar name value.
In QV12 is appears to be necessary to create two separate tables to achieve the name result.
In both QV11 and QV12 I get two rows.
There was a bug back in QV12Sr1 that matches what you are describing. What release of QV12 are you using?
View solution in original post
Version12.0.20001.0 SR1 64-bit. I have upgraded to QV12.10.20600.0 SR8 and all sorted. thanks