Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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?

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

View solution in original post

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.