Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Unable to view the long digit number

Hi All,

I am trying to load the data from a table but i couldn't see the values for one column names RecID. In table, the column is loading through Identity value. The values are as below.

10000000075607570,100000000075607571 so on.

Data is loaded without errors but i couldn't see the values in dashboard. It is one key column and used for joins. Please guide to resolve this issue.

7 Replies
ariel_klien
Valued Contributor

Re: Unable to view the long digit number

HI,

Try load with num(RecID) or with Text(RecID)

BR

Ariel

Not applicable

Re: Unable to view the long digit number

Tried this, but values are not coming properly.

1.png

Not applicable

Re: Unable to view the long digit number

Tried this, but values are not coming properly.

1.png

ariel_klien
Valued Contributor

Re: Unable to view the long digit number

Hi

go to document properties (Alt+Ctrl+D) > Number > and change the format of the field.

BR

Ariel

MVP
MVP

Re: Unable to view the long digit number

Try to load your values using evaluate():

LOAD

     evaluate(RecID) as RecID,

     ...

er_mohit
Honored Contributor II

Re: Unable to view the long digit number

try this

num#(fieldname)

anandathome
Contributor

Re: Unable to view the long digit number

Could you give a view of your LOAD script?

Community Browser