Maintain Number Format of Excel Import

[danielle_v]

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!

[sushil353 · Accepted solution]

Hi,

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

[PrashantSangle]

Hi,

try

FindOneOF()

like

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

Regards

[danielle_v]

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