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: 
andreyfcdk91
Creator
Creator

num format in expression ->display data in excel

Colleagues, good day!

I have some problem with export data and it's display in excel file.

In same expression in QV pivot i calculate expr with manually setting format. (in one expr i calculate absolute values and percents.)

For example: if(dim=1, num(count(sales)/count(Total sales), '###,#%'),

                                 num(count(sales)))

when the data is exported to xls, excel file can't recognize number format of values and requests to change format:


dsdsdsd.png

Can i set manually format of data in expr to export data to excel in number format?

Thanks.

5 Replies
kuczynska
Creator III
Creator III

Hi,

Are you sure that "Expression Default" option is selected for this expression on Number tab in object properties?

Also make sure that the "else" part of your statement has a correct number format set, i.e. copy '###,#%' to that part too.

el_aprendiz111
Specialist
Specialist

Hi,

Sometimes it happens, I solve it


(Expression)*1

andreyfcdk91
Creator
Creator
Author

Hi, of course, Expression Default is selected.

Don't understand what i must copy to what part of expr? Can you show in example?

Thanks.

andreyfcdk91
Creator
Creator
Author

Hi!

Thanks, dear.

But when i add *1 after all expression, some percent values was converted to simple integer..

johncaqc
Specialist
Specialist

Try setting the field value 'sales' to a number in the document properties.

HTH,

John