
Creator II
2018-10-17
05:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression help
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.
1,185 Views
1 Solution
Accepted Solutions

Partner - Creator
2018-10-17
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did u try?
(
Fabs(Sum([Sales 30]))+Fabs(Sum([Cost 30]))
)
/
Fabs(
Fabs(Sum([Sales 60]))
-
Fabs(Sum([Cost 60]))
)
1,094 Views
4 Replies

Partner - Creator
2018-10-17
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did u try?
(
Fabs(Sum([Sales 30]))+Fabs(Sum([Cost 30]))
)
/
Fabs(
Fabs(Sum([Sales 60]))
-
Fabs(Sum([Cost 60]))
)
1,095 Views


Creator
2018-10-17
07:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Mahitha:
Please check the attached file and let know if anything else is your requirement.
-- Shafi
1,094 Views

Creator II
2018-10-17
07:53 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ahammadshafi,
Could you please attach the qliksense file I don't have the Qlikview license.
1,094 Views


Creator
2018-10-17
08:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Mahitha:
Here is the QlikSense file.
-- Shafi
1,094 Views
