Duplicate

[smilingjohn]

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

[YoussefBelloum]

Hi,

try with floor() or ceil()

like this on the script:

Floor(Roll_ID) as Roll_ID

or

Ceil(Roll_ID) as Roll_ID

[YoussefBelloum]

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

[smilingjohn]

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

[YoussefBelloum]

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 ?

[smilingjohn]

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

[YoussefBelloum]

you will need this:

text(trim(Roll_ID)) as Roll_ID

[smilingjohn]

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

[YoussefBelloum · Accepted solution]

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..