topic Tablebox erases duplicated row. in QlikView

Tablebox erases duplicated row.

mokitsu61 — Thu, 14 Jun 2018 08:16:54 GMT

Hi,

TestData:

Load

　RowNo() AS NO,

Inline [

A,B,C

US,100,80

JP,300,250

];

I want to show 3 rows in Tablebox, but Tablebox erases duplicated row (US,100,80) and it shows only 2 rows automatically.

Does anyone know how to show 3 rows in Tablebox?

Thank you.

Re: Tablebox erases duplicated row.

mayankraoka — Thu, 14 Jun 2018 08:23:16 GMT

Hi,

Table box only shows unique records and it will remove the duplicate rows. For that if there are duplicate rows, the only way to separate them is to add a uniques field, for example RowNo() as ID.

Regards,

Mayank

Re: Tablebox erases duplicated row.

YoussefBelloum — Thu, 14 Jun 2018 08:28:19 GMT

Hi,

just add the field you created "NO" on the tablebox and you will see your 3 lines.. otherwise duplicate line will be erased

Re: Tablebox erases duplicated row.

mokitsu61 — Thu, 14 Jun 2018 08:33:31 GMT

Thank you for your replying.

I see.

You give me a correct answer but let me make fast reply as "Answer".

Thank you.

Re: Tablebox erases duplicated row.

YoussefBelloum — Thu, 14 Jun 2018 08:41:54 GMT

You're welcome