Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III

Keep duplicate values while loading

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 1Header 2Header 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

5 Replies
sunny_talwar

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])

sunny_talwar

Here is an example to look at

Capture.PNG

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

marcus_sommer

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

vireshkolagimat
Creator III
Creator III
Author

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

sunny_talwar

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