Display all records in Qlik Sense Table without distinct

[vidyas16]

Dear All,

Like in data base if distinct is not mentioned, it displays all the records in result set. Can we do the same in Qliksense?

Please see the example below

As a workaround currently I have added rowno() in the script, to display all the records. Could you please suggest if any changes can be made at the front end to get the desired result as database.

Thank you in advance.

Vidya

[Dalton_Ruer · Accepted solution]

Using RowNo() in the script is usually a great idea anyway so that if there is every a challenge about the data you have an entry to show the uniqueness, like in this case show that it really did come in multiple times.

If there are any other fields already in the data you can use those instead to show uniqueness.

[vidyas16]

Thank you for the reply. I will proceed with the same way .