topic Re: "OR" Condition in Set Analysis in QlikView

"OR" Condition in Set Analysis

Anonymous — Thu, 09 Oct 2014 15:36:40 GMT

What is the syntax to express an "or" condition in a Set Analysis statement? For example I want to get the sum of ORIGBAL when OPENDATE or CLOSEDATE fall within a variable date parameter. I can test only OPENDATE with the following statement..

=SUM ({$<OPENDATE={'>=$(vSelectedMinDate)<=$(vSelectedMaxDate)'}>}ORIGBAL)

How do I test for either OPENDATE OR CLOSEDATE to be within the date parameter to sum the balance?

Thanks for the help

Re: "OR" Condition in Set Analysis

phaneendra_kunc — Thu, 09 Oct 2014 15:43:24 GMT

Try this format.

SUM({<FIELD1 = {1}> + <FIELD2 = {2}>}Sales)

Re: "OR" Condition in Set Analysis

jyothish8807 — Thu, 09 Oct 2014 15:50:33 GMT

Hi Edward,

The '+' sign is or in set analysis.

=SUM ({$<OPENDATE={'>=$(vSelectedMinDate)<=$(vSelectedMaxDate)'}> + <CLOSEDATE={'>=$(vSelectedMinDate)<=$(vSelectedMaxDate)'}>}ORIGBAL)

Regards

Re: "OR" Condition in Set Analysis

Anonymous — Thu, 09 Oct 2014 16:22:53 GMT

Thanks for the help. I read through the Set Analysis help screens and did not find any reference as to how to join statements together.

Thanks again.

Re: "OR" Condition in Set Analysis

jyothish8807 — Thu, 09 Oct 2014 16:26:17 GMT

You are welcome

Regards