topic Records displayed not as many as lines fetched shown during Script Execution Progress in QlikView

Records displayed not as many as lines fetched shown during Script Execution Progress

Fri, 18 Jul 2014 04:36:08 GMT

Hi guys,

This is a noob question that I'm about to ask.

Upon loading a script, in the Script Execution Progress dialog shows that there are some 2mill++ lines being fetched.

So after loading completed, I put a Table Box object and select all of the fields available. But the number of records shown are way lesser that the ones shown in the Script Execution Progress dialog which is 4k++ rows.

There were no selection being made so I was puzzled of the count differences. Can somebody explain to me why this is happening?

Thank you for your kind attention guys.

Re: Records displayed not as many as lines fetched shown during Script Execution Progress

Fri, 18 Jul 2014 04:41:54 GMT

Hi,

The table box will display distinct records.

So if all values in a record are repeated, they'll be displayed once.

This could be what's happening in your case.

Re: Records displayed not as many as lines fetched shown during Script Execution Progress

Fri, 18 Jul 2014 04:46:07 GMT

Hi jp_bakhache,

Thank you for your kind attention. Is there anyway to undistinct the table box?

Re: Records displayed not as many as lines fetched shown during Script Execution Progress

Fri, 18 Jul 2014 04:51:31 GMT

Not as far as I know.

If you want, you can add in your script a field as rowno() that will uniquely identify your record and add that in your table box:

Load RowNo() as UniqueID,

etc...