topic Re: Datatype not clear in QlikView

Datatype not clear

dominikkeller — Sat, 16 Nov 2024 19:31:01 GMT

Hello everybody,

in the following picture you can see my problem quite well i have 35 outlets in my qvd. These are later but not all matched with the plain names. What I do not understand, what makes the top 8 different from the others. The tableviewer shows me that it is $ numeric and $ integer.

I tried to solve the problem with num and trim, but I lose the 8 outlets.

Could anyone of you help me out?

Re: Datatype not clear

Anil_Babu_Samineni — Thu, 05 Dec 2019 11:35:01 GMT

By seeing image, You have date with Text+Number data. Qlik always read with Text as Left alignment and Number as Right alignment. Henceforth, Qlik always recommends for best practice to keep either number or Text if all digits as Num data type and all digits as Text as Char/Varchar etc.

Re: Datatype not clear

dominikkeller — Thu, 05 Dec 2019 11:47:28 GMT

Thanks for the quick reply, but im not sure what i can do to format the text entries..when i'm using num(standorte.id) the "problem" entries didn't show up.

Re: Datatype not clear

Anil_Babu_Samineni — Thu, 05 Dec 2019 11:52:21 GMT

Perhaps this with, We really don't know the real values of the string in DB if you pull from DB ?

Num(Num#(standorte.id)) as standorte.id

Re: Datatype not clear

dominikkeller — Fri, 13 Dec 2019 16:33:07 GMT

Hey Anil,

thanks for your help.

I found another solution.

The Data comes from an API Call. The ID's with more than 14 characters changed to the text format by default.

I could solve it with: num(evaluate(standorte.id)

Thank you