Expression help

[mahitham]

Hi Experts,

Can any one please help me to put below formula in Qlik

how to convert denominator mod || in Qlik expression.

Here

Sales 30 = Fabs(Sum([Sales 30]))

Sales 60 = Fabs(Sum([Sales 60]))

Cost 30 = Fabs(Sum([Cost 30]))

Cost 60= Fabs(Sum([Cost 60]))

Thanks in advance.

[vishus913 · Accepted solution]

Did u try?

(

Fabs(Sum([Sales 30]))+Fabs(Sum([Cost 30]))

)

/

Fabs(

Fabs(Sum([Sales 60]))

-

Fabs(Sum([Cost 60]))

)

[ahammadshafi]

Hi Mahitha:

Please check the attached file and let know if anything else is your requirement.

-- Shafi

[mahitham]

Hi ahammadshafi,

Could you please attach the qliksense file I don't have the Qlikview license.

[ahammadshafi]

Hi Mahitha:

Here is the QlikSense file.

-- Shafi