Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
=Sum({$<Name={'ABC','XYZ'} ,City={'Paris'}>} Salary)
, (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.
Thanq Mr. Chaitanya.