Discussion Board for collaboration related to QlikView App Development.
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), '###,#%'),
when the data is exported to xls, excel file can't recognize number format of values and requests to change format:
Can i set manually format of data in expr to export data to excel in number format?
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.
Sometimes it happens, I solve it
Hi, of course, Expression Default is selected.
Don't understand what i must copy to what part of expr? Can you show in example?
But when i add *1 after all expression, some percent values was converted to simple integer..
Try setting the field value 'sales' to a number in the document properties.