topic Keep duplicate values while loading in QlikView

Keep duplicate values while loading

vireshkolagimat — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have data in the below format and i want to keep duplicate values after reload.

By default qlikview stores the distinct values. How to overwrite this behavior.

Header 1	Header 2	Header 3
Group A
category1
category2
Group B
category1
category2

If i reload the above data, it will load only the rows Group A,category1, category2,Group B and i will miss out another 2 rows.

Regards,

Viresh

Re: Keep duplicate values while loading

sunny_talwar — Fri, 08 Jul 2016 14:46:47 GMT

That is not true, QlikView won't keep distinct values unless you tell it to. You won't see the duplicate values in a table box, but that doesn't mean they are not loaded.

Try doing a count of them in straight table.

Dimension:

Header 1

Expression

Count([Header 1])

Re: Keep duplicate values while loading

sunny_talwar — Fri, 08 Jul 2016 14:48:27 GMT

Here is an example to look at

Table box show a single A, but Table Viewer show 2 As

Re: Keep duplicate values while loading

marcus_sommer — Fri, 08 Jul 2016 14:48:56 GMT

Even that qlik stored only unique values you won't loose duplicate values if you don't apply a DISTINCT within your load. But you will need an unique row-identifier with recno() and/or rowno() to see those duplicates within a tablebox which will only show unique field-combinations.

- Marcus

Re: Keep duplicate values while loading

vireshkolagimat — Sun, 10 Jul 2016 16:24:19 GMT

Hi, in this case,i want to see both A in a table.

Re: Keep duplicate values while loading

sunny_talwar — Sun, 10 Jul 2016 16:27:24 GMT

Then as marcus_sommer‌ mentioned below add another field using RowNo() or RecNo() which assign each instance of A a unique identifier and use that identifier in your table box object