topic Re: Distinct field in straight table in QlikView

Distinct field in straight table

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

Hi,

I have a straight table in that i have claimnumber, date etc. in my straight table one claimnumber repeated multiple times.but i want distinct claimnumber in straight table.

I tried with concat and FirstSortedValue(DISTINCT ClaimNumber,date,-1) but this is not getting the output. Please can any one tell me the solution for this. Please find the sample data file

Re: Distinct field in straight table

Siva_Sankar — Mon, 05 Jun 2017 09:27:41 GMT

Hi Shabarish,

Each claim number have multiple IDs and cant be consider as duplicate.In some cases, there are many claims on different dates.

What you want to show in dimension and in expression?

Share the expected output.

Siva

Re: Distinct field in straight table

shabarish0587 — Mon, 05 Jun 2017 09:38:15 GMT

Hi Sivasankar,

I dont want ids in my table. We can remove ids and i want show the output in dimension.

Re: Distinct field in straight table

PrashantSangle — Mon, 05 Jun 2017 09:53:36 GMT

Hi,

What is your required output???

Regards,

Prashant

Re: Distinct field in straight table

Siva_Sankar — Mon, 05 Jun 2017 09:54:56 GMT

find the attached qlikview. if you add date in the dimension you will see multiple records, reason is the claim number appeared in different dates or claims done on multiple dates.

-Siva

Re: Distinct field in straight table

shabarish0587 — Mon, 05 Jun 2017 10:05:27 GMT

Hi Sivasankar,

I am expecting the output what you have send that is correct but i want date with claimnumber.

like claimnumber with latest date only can you tell me how to do this