topic Re: num format in expression ->display data in excel in QlikView

num format in expression ->display data in excel

Anonymous — Wed, 09 Nov 2016 10:00:41 GMT

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:

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

Thanks.

kuczynska — Wed, 09 Nov 2016 13:40:43 GMT

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 — Wed, 09 Nov 2016 13:44:57 GMT

Hi,

Sometimes it happens, I solve it

(Expression)*1

Anonymous — Thu, 10 Nov 2016 06:51:47 GMT

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.

Anonymous — Thu, 10 Nov 2016 06:53:16 GMT

Hi!

Thanks, dear.

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

johnca — Mon, 21 Nov 2016 02:20:18 GMT

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

HTH,

John