topic Re: Maintain Number Format of Excel Import in QlikView

Maintain Number Format of Excel Import

danielle_v — Wed, 10 Jun 2015 11:10:35 GMT

Hi All,

I am importing an Excel table into Qlikview, as per the below extract;

Area	Measure	Year	Jan	Feb
ABC	Value	2014	£1,234,766	£2.367,720
ABC	%	2014	2.1%	3.3%
DEF	Value	2014	£3,331,755	£2,776,637
DEF	%	2014	1.9%	4.8%

In the front end of my report, I am creating a pivot table out of this data and need all of the figures to maintain the same format as they have in the source file - so there should be a mixture of £ values and % values.

However, I can't see if there's a way of having multiple number formats per expression (in my case, an expression would be sum(Jan), sum(Feb) etc., with Area, Measure and Year as the dimensions).

Is there a way of doing this at all?

Any help much appreciated!

Re: Maintain Number Format of Excel Import

sushil353 — Wed, 10 Jun 2015 11:17:44 GMT

Hi,

You can use NUM() function with condition to specify desired no format.

Re: Maintain Number Format of Excel Import

PrashantSangle — Wed, 10 Jun 2015 11:21:33 GMT

Hi,

try

FindOneOF()

if(findOneOf(FieldName,'%')>0,num(fieldName,'#,#0.0%'),num(fieldName,'£#,###,#00'))

Regards

Re: Maintain Number Format of Excel Import

danielle_v — Wed, 10 Jun 2015 12:48:29 GMT

Thanks Sushil - I added an if statement into my expression and used the NUM function within this