Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

Re: Help with a conditional sum

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

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