Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
declanhunt
New Contributor

Help with a conditional sum

I have a fact table with LineTotal reflecting the value of each transaction a CustomerID linking the sale to a customer dimension.

Within the customer dimension, there is an attribute called Hemisphere with a value of N for Northern or S for Southern.

How do I write a function for a measure that will only sum LineTotal when a customer lives in the relevant hemisphere?

Tags (2)
1 Reply
Luminary
Luminary

Re: Help with a conditional sum

North: Sum({<Hemisphere={'N'}>}LineTotal)

South: Sum({<Hemisphere={'S'}>}LineTotal)