Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?

1 Reply
Ivan_Bozov
Luminary
Luminary

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

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

vizmind.eu