using "OR" in Set analysis

[markgraham123]

Hi all,

I was trying to use '+' in the place of OR in the set analysis:

Can some one help me on this:

If Name is ABC or XYZ and City is Paris, i was trying to sum the salary using Set analysis:

Trying for Set analysis for the below statement:

=Sum(If((Name='ABC' or Name='XYZ') and City='Paris', Salary))

[Qrishna · Accepted solution]

=Sum({$<Name={'ABC','XYZ'} ,City={'Paris'}>} Salary)

[#3]

, (comma) separators will give you the sought after result.  In your modifier Name={'ABC','XYZ'}, City={'Paris'}.

As you are starting out with Set Analysis, I would suggest that you become familiar with the Set Analysis Wizard --> Set Analysis Wizard for QlikView | qlikblog.at

Very helpful tool to get you started for simple expressions like this one.

[markgraham123]

Thanq Mr. Chaitanya.