topic Re: Exporting to excel in QlikView

Exporting to excel

rido1421 — Tue, 11 Nov 2014 11:15:49 GMT

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,

Re: Exporting to excel

its_anandrjs — Tue, 11 Nov 2014 11:23:34 GMT

Hi,

In expression use Fabs for ignore negative values

Ex:-

Fabs(Sum(Metrics))

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

Regards

Anand

Re: Exporting to excel

rido1421 — Tue, 11 Nov 2014 11:29:13 GMT

Hi Aanand

this is qlikview syntax?

Re: Exporting to excel

Tue, 11 Nov 2014 12:28:54 GMT

Hi,

Yes these are the qlikview syntax's

Fabs(Sum(Metrics))

and

Sum(Metrics) * -1

Re: Exporting to excel

rido1421 — Tue, 11 Nov 2014 13:00:28 GMT

Thank you

although I was looking to solve the issue in excel

I have changed my expressions and solved the issue

Regards