Pick Only Unique Records

[risabhroy_03]

I have a table and I only want to pick distinct records.

For a set of data only single row is coming in a straight table but actually records are duplicated because Qlik automatically hide those rows.

I want to remove them from my QVD because when I put a count function, Instead of getting 1 in every row I am getting higher values.

[Digvijay_Singh]

You may need to use load distinct in your script while loading them in QVD, or use distinct in the measure of your straight table to avoid duplicates.

[risabhroy_03]

I used distinct but it is not working as I have no impact on my data.

[fallenangel6]

Please see which field is causing that. take all fields of the table in a table chart and check. maybe some fields like flags might have different values and so it would appear like distinct isnt working, but in true both records have some field which might have different values. it could even be date-time fields with difference in seconds.