Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramshoney
Contributor

Numeric Data Type

Hi I have two tables.

Table A has ID, IDName  ( Both ID and IDNumber are Int datatype)

001,AAA

002,BBB

003,CCC

Table B has ID, Sum ( ID and Sum are String Data type)

001,1000

002,2000

003,3000

In my Script Load

i converted the  ID

Num#(ID) from Table B

but im not able to sort the SUM in the report.

6 Replies
kenphamvn
Contributor III

Re: Numeric Data Type

hi

With ID as above, you do not need convert to number for sorting

Please check Sort Property panel and make sure ID column on Top

Regards

An Pham

shraddha_g
Honored Contributor III

Re: Numeric Data Type

You stated ID and Sum both are in String Format,then you will also have to do Num#(Sum) to convert it into Number Format.

ramshoney
Contributor

Re: Numeric Data Type

An Pham, Thanks for the reply. I did that analysis didnt work for me.

ramshoney
Contributor

Re: Numeric Data Type

TShraddha Thanks for the reply,

Ya i apply the Num#() to both the fields. But Sorting not working with sort function where sorting working with Alphabets of String.

shraddha_g
Honored Contributor III

Re: Numeric Data Type

Can you share sample app?

Else provide Screenshots of what you have done in chart

Chanty4u
Esteemed Contributor III

Re: Numeric Data Type

try in sort tab

match(id,'001','002','003')

Community Browser