topic Re: Formula not working on report in QlikView

Formula not working on report

qlikviewaf — Wed, 20 Sep 2017 08:18:15 GMT

Hi Guys,

i created a dynamic table that is build based on the dimension/measure selected.

Everything is working except the margin which is easy to be calculated ( SALES - COST ) / SALES

=SUM((ExtendedUSD - ExtendedCostUSDADJ)/(ExtendedUSD))

as you can see below the margin is 1,119 which is wrong, should it be 0,50 (50%)

hari8088 — Wed, 20 Sep 2017 08:21:56 GMT

Try like this.

(SUM((ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))

after this in chart properties number tab change to percentage for this expression

qlikviewaf — Wed, 20 Sep 2017 08:24:07 GMT

not working

mdmukramali — Wed, 20 Sep 2017 08:27:33 GMT

Dear,

use the below expression:

=(SUM(ExtendedUSD) - sum(ExtendedCostUSDADJ)) / sum(ExtendedUSD)

=(Sum(SUM(ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))

Anil_Babu_Samineni — Wed, 20 Sep 2017 08:30:17 GMT

Check this? and enable the % from number format

=Num((SUM(ExtendedUSD) - Sum(ExtendedCostUSDADJ))/Sum(TOTAL ExtendedUSD),'#,##0%')

hari8088 — Wed, 20 Sep 2017 08:30:28 GMT

Don't give two sum in starting

(SUM((ExtendedUSD) - sum(ExtendedCostUSDADJ))/sum(ExtendedUSD))