Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mahitham
Contributor

Expression help

Hi Experts,

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

how to convert denominator mod || in Qlik expression.

Mod expression.png

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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Expression help

Did u try?

(

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

)

/

Fabs(

Fabs(Sum([Sales 60]))

-

Fabs(Sum([Cost 60]))

)

4 Replies
Partner
Partner

Re: Expression help

Did u try?

(

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

)

/

Fabs(

Fabs(Sum([Sales 60]))

-

Fabs(Sum([Cost 60]))

)

ahammadshafi
Contributor

Re: Expression help

Hi Mahitha:

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

-- Shafi

mahitham
Contributor

Re: Expression help

Hi ahammadshafi,

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

ahammadshafi
Contributor

Re: Expression help

Hi Mahitha:

Here is the QlikSense file.

-- Shafi