topic using "OR" in Set analysis in QlikView

using "OR" in Set analysis

markgraham123 — Thu, 15 Oct 2015 20:12:55 GMT

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 — Thu, 15 Oct 2015 20:15:37 GMT

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

Thu, 15 Oct 2015 21:06:07 GMT

, (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 — Thu, 15 Oct 2015 21:37:24 GMT

Thanq Mr. Chaitanya.