Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikBeginner1
Creator
Creator

Merge multiple expressions into one

Hey,

I am building a report, and have multiple requirements to build this report out. I have build this out which is looking OK so far, however I am not sure this is the most efficient way. Is this how you would achieve the below requirements?:

= Sum(IF(TransactionPostedDate = PolicyInceptionDate OR
ConfTransactionSubStatusDesc = 'New Business' OR
ConfTransactionSubStatusDesc = 'Renewal' OR
ConfTransactionSubStatusDesc = 'Mid Term Adjustment' OR
ConfTransactionSubStatusDesc = 'Cancellation'
and PolicyEffectiveDate < vReloadDate, GrossWrittenPremium))

 

QlikBeginner1_0-1607011229132.png

The Transaction Date field currently is removing Nulls. so the first requirement is met.

Thanks in advance

Labels (1)
2 Replies
ibdK4evr
Contributor III
Contributor III

Hi ,

Regarding the above ,for all the conditions you will be applying sum on the GrossWrittenPremium measure ? 

QlikBeginner1
Creator
Creator
Author

Hi, 

So I thought if you added these conditions into a measure in the table, this reflects to all the fields in that table ?  So I have a list of fields that is the output, and GWP is one of the columns. I have two reports that I am building, so cannot limit the data in the back end to these specific rules. Hope this makes sense?