Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

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
vishus913
Partner - Creator
Partner - Creator

Did u try?

(

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

)

/

Fabs(

Fabs(Sum([Sales 60]))

-

Fabs(Sum([Cost 60]))

)

View solution in original post

4 Replies
vishus913
Partner - Creator
Partner - Creator

Did u try?

(

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

)

/

Fabs(

Fabs(Sum([Sales 60]))

-

Fabs(Sum([Cost 60]))

)

ahammadshafi
Creator
Creator

Hi Mahitha:

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

-- Shafi

mahitham
Creator II
Creator II
Author

Hi ahammadshafi,

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

ahammadshafi
Creator
Creator

Hi Mahitha:

Here is the QlikSense file.

-- Shafi