Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rido1421
Contributor II

Exporting to excel

HI All

I have a model with an income statement in a chart using a UDR

When i export to excel the figures in brackets - the negatives come through as text... I need them to come through as a number

is there perhaps a way to convert this in excel? i think it would be easier for me to show my end user how to do this instead of change all my expressions

I have attached the file ...

Regards,

4 Replies

Re: Exporting to excel

Hi,

In expression use Fabs for ignore negative values

Ex:-

Fabs(Sum(Metrics))

Or

Sum(Metrics) * -1 //if there are only ( - ive )values

Regards

Anand

rido1421
Contributor II

Re: Exporting to excel

Hi Aanand

this is qlikview syntax?

Not applicable

Re: Exporting to excel

Hi,

Yes these are the qlikview syntax's

Fabs(Sum(Metrics))

and 

Sum(Metrics) * -1

rido1421
Contributor II

Re: Exporting to excel

Thank you

although I was looking to solve the issue in excel

I have changed my expressions and solved the issue

Regards

Community Browser