Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ashish_2511
Creator
Creator

Excel Export - Numbers as Text

 

Dear Community members -

 

I've a load field called TP which is calculated this way in the script -

 

IF (TP < 10, Num(TP,'#,##0.00'), If(TP >= 10 and TP < 100, Num(TP,'#,##0.0'), Num(TP,'#,##0'))) as TP

 

Condition is -

  

TP < 10 - 2 decimal points,

 

TP >=10 and TP<100 - 1 decimal point,

 

Else TP has no decimal point.

 

Then I’m using this field in a straight table but when I export it to excel it exports in ‘number converted as text’ format in excel.

 

I’ve seen many posts and tried many solutions nothing helped me. If the field didn’t have the above mentioned condition then it’s exporting in correct format.

 

Any help will be appreciated.

 

Thanks in advance.

 

1 Solution

Accepted Solutions
ashish_2511
Creator
Creator
Author

I solved this by using round function in an expression. It doesn't solve my problem fully but serves the purpose for now.

Anybody gets any idea on this do reply on this post. I'm closing this discussion.

Thanks! for all your replies.

Cheers!

View solution in original post

5 Replies
Anonymous
Not applicable

I Format such an Expression as calculated Dimension or as Expression (whereever you want it)

if Expression you may Need an Expression like sum et.c

Image was just as example (left is calculated Dimension, right isExpression)

IF (TP < 10, Num(TP,'#,##0.00'), If(TP >= 10 and TP < 100, Num(TP,'#,##0.0'), Num(TP,'#,##0')))

ashish_2511
Creator
Creator
Author

Hi Rudolf

Thanks for that

but I've already tried this. It still exports as 'numbers stored as text'

vipin_mishra479
Creator II
Creator II

Try Round function

=Round(86.656982, 0.01)

=Round(86.656982, 0.1)

=Round(86.656982, 0)


Hope this will help !!

ashish_2511
Creator
Creator
Author

I tried this as a calculated dimension but didn't work.

   

=If(TP < 10, Round(TP,0.01), If(TP >= 10 and TP < 100, Round(TP,0.1), Round(TP,0)))
//TP
-
0.94
2.3
3.5
3.9
3.5
4.5
-
ashish_2511
Creator
Creator
Author

I solved this by using round function in an expression. It doesn't solve my problem fully but serves the purpose for now.

Anybody gets any idea on this do reply on this post. I'm closing this discussion.

Thanks! for all your replies.

Cheers!

View solution in original post