https://community.qlik.com/t5/App-Development/No-coming-as-text-downloaded-from-qlik-sense/m-p/1949847#M78273 <P>Hello All,</P> <P>I'm facing issue with no formatting in qlik sense. Exporting data to excel giving the no's as text. When the user is selecting&nbsp; 2 cells it is showing count instead of sum. The error is showing as the format is in text. I have a measure field which contains both text and no. In the script I have used num#(field) and on the Ui expression I gave custom number format like if(dim ='ABC', only(measure),num(sum(measure),'#,##0.00') . I tried other ways checking the community but no luck. Please can someone help on this?&nbsp;&nbsp;</P> <P>Thanks</P> Wed, 29 Jun 2022 16:19:07 GMT dandaanilreddy 2022-06-29T16:19:07Z https://community.qlik.com/t5/App-Development/No-coming-as-text-downloaded-from-qlik-sense/m-p/1949847#M78273 <P>Hello All,</P> <P>I'm facing issue with no formatting in qlik sense. Exporting data to excel giving the no's as text. When the user is selecting&nbsp; 2 cells it is showing count instead of sum. The error is showing as the format is in text. I have a measure field which contains both text and no. In the script I have used num#(field) and on the Ui expression I gave custom number format like if(dim ='ABC', only(measure),num(sum(measure),'#,##0.00') . I tried other ways checking the community but no luck. Please can someone help on this?&nbsp;&nbsp;</P> <P>Thanks</P> Wed, 29 Jun 2022 16:19:07 GMT https://community.qlik.com/t5/App-Development/No-coming-as-text-downloaded-from-qlik-sense/m-p/1949847#M78273 dandaanilreddy 2022-06-29T16:19:07Z