topic Re: Autosum not working in Qlik NPrinting

Autosum not working

Mon, 18 Jul 2016 07:34:15 GMT

Hi, I've hit an excel issue with the Sum() function. When I use it on the data i get e.g. £ - but if I add the cells manually it works. Please see below image for what the issue looks like. I've tried various combinations on the template/QV document of number/currency etc.

this is a screen shot taken from the previewed template.

Thanks for any help

Re: Autosum not working

marcus_sommer — Mon, 18 Jul 2016 10:56:23 GMT

I think the reason is that your values aren't numeric else strings and by adding them manually together you start an automatic conversation which didn't apply by using the sum-function.

If you want to load these data then into qlikview you will be very probably need some transforming on the data so that they will be interpreted as numbers, maybe something like this:

num(keepchar(YourField, '0123456789,')

and further have a look on The Crosstable Load to transform the datastructure of your table.

- Marcus

Re: Autosum not working

Mon, 18 Jul 2016 14:12:01 GMT

Yes, the data is in Text format,

Thanks a lot.

- itsdanny