topic Re: Convert text to numeric in QlikView

Convert text to numeric

ashis — Wed, 25 Nov 2020 16:16:04 GMT

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 .

Re: Convert text to numeric

Anil_Babu_Samineni — Tue, 09 Jan 2018 05:48:50 GMT

Image please?

Re: Convert text to numeric

ashis — Tue, 09 Jan 2018 05:54:42 GMT

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.

Re: Convert text to numeric

devarasu07 — Tue, 09 Jan 2018 05:54:43 GMT

Hi,

have u tried with custom format method?

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

Then add in Text Color Expression:

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

Re: Convert text to numeric

ashis — Tue, 09 Jan 2018 06:06:32 GMT

Thank you for your reply. Will try your method.

Regards,

Ashis

Re: Convert text to numeric

devarasu07 — Tue, 09 Jan 2018 06:10:19 GMT

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