topic Re: Duplicate in QlikView

Duplicate

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

Hi All,

Please find the attachment of the Qlikview file..

Here i have a filter called Roll ID

in which i see duplicate values ...(18.5.2 two times)

How can i make this unique ..

Need help

Thanks in advance

Re: Duplicate

YoussefBelloum — Wed, 09 May 2018 14:57:12 GMT

Hi,

try with floor() or ceil()

like this on the script:

Floor(Roll_ID) as Roll_ID

Ceil(Roll_ID) as Roll_ID

Re: Duplicate

YoussefBelloum — Wed, 09 May 2018 15:14:06 GMT

what is the original and the expected format of this field ?

Re: Duplicate

smilingjohn — Wed, 09 May 2018 15:17:00 GMT

If you look in the Roll_ID filter

there is double time 18.5.2 listed which should be displayed only one time ..

Can you please tell me why is this happening ?

it should display it only once just like others

Re: Duplicate

YoussefBelloum — Wed, 09 May 2018 15:21:01 GMT

yes I see it, that's why I was asking for the original format ? it is a QVD, you're not formatting this field on the first load when you're storing the qvd ?

Re: Duplicate

smilingjohn — Wed, 09 May 2018 15:23:40 GMT

Hi Youssef

I am fetching thi from oracle DB and getting this field as '

Text (Roll_ID ) as Roll_ID then storing it into QVD

Re: Duplicate

YoussefBelloum — Wed, 09 May 2018 15:50:24 GMT

you will need this:

text(trim(Roll_ID)) as Roll_ID

Re: Duplicate

smilingjohn — Wed, 09 May 2018 16:02:50 GMT

Thanks Youssef ,

This is working .. i have a doubt will this make any changes to the other calculations ? i mean to ask will this effect by ignoring some records ? IF you can please tell me how does this work then it will be great full

Thanks

Re: Duplicate

YoussefBelloum — Wed, 09 May 2018 16:09:50 GMT

I was asking for the format because it can be num or text field.

so I used trim()

Trim() returns the input string trimmed of any leading and trailing spaces.

it is basically to be sure that the value 18.5.2 will be the same on every row (if there is left or middle or right spaces on any row).

and used Text() function to format it again as text field..

but you should make some tests to see if it is not causing any change on your calculations..