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 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?
