topic Re: Same rows not showing in Straight table in QlikView

Same rows not showing in Straight table

narender123 — Wed, 25 May 2016 06:52:41 GMT

Hi All,

I have 2 tables and both are joined with each other via association join by default.

When i load the data and create straight table then some of the rows are not showing .The reason behind this is :

Rows with same data are not showing in table means same repeating rows showing only 1 time.

But in oracle data all rows are showing independent of same or different rows.

Please tell me how to show all rows, independent of similarity between rows.

Thanks,

Narender

Gysbert_Wassenaar — Wed, 25 May 2016 07:04:54 GMT

Create a record number in the script when you load the data:

LOAD

RecNo() as RecordNumber

FROM

...somewhere...

;

Then use that RecordNumber field as dimension in your straight table.

narender123 — Wed, 25 May 2016 07:25:26 GMT

Thanks Gysbert.

I used it and its working.

kamal_sanguri — Wed, 25 May 2016 07:31:45 GMT

Nice trick..