Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashis
Creator III
Creator III

Convert text to numeric

I  have a straight table and one expression that has the following expression

if((Column(1) - Column(3)) >=0,
    chr(9650),chr(9660) &'  '&
num(($(vVariable1) - $(vVariable2)) /$(vVariable2),'#,##0.0%')

this is giving me up and down arrow as well as the percentage change . However this is turning into
text instead of numeric value. For that i am not able to sort the value.

Could you please help me how to make the whole expression as numeric .

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

Hi,

have u tried with custom format method?

▲ #,##0;▼ #,##0

Then add in Text Color Expression:

if(sum(Amount)>0,Green(),Red())


Capture.JPG

View solution in original post

5 Replies
Anil_Babu_Samineni

Image please?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
ashis
Creator III
Creator III
Author

Hi Anil,

One good way to understand this is text not number , going to presentation tab and that expression

Data(Numeric) right align and Data(Text) Center align.

Now if it is numeric it would be right align and if it is text it would come in the center.

My expression is showing in the center , so I come to know it is interpreting as text.

Due to security I can not show image, sorry for that.

devarasu07
Master II
Master II

Hi,

have u tried with custom format method?

▲ #,##0;▼ #,##0

Then add in Text Color Expression:

if(sum(Amount)>0,Green(),Red())


Capture.JPG

ashis
Creator III
Creator III
Author

Thank you for your reply. Will try your method.

Regards,

Ashis

devarasu07
Master II
Master II

Ok sure, in this method exported output still remain number. so it should work as expected.