Nested IF or Some Other Function ?

Anonymous — Wed, 10 Jul 2013 15:28:38 GMT

I need to create a chart (straight table) from a dataset similar to attached Excel. Requirement is to pick Client Name (and rest of the row):

if Area Name = Research and Type = Region and Rank value exists then pick that row

else if Area Name = Overall and Type = Region and Rank value exists then pick that row

esle if Area Name = Overall and Type = Overll and Rank vlaue exists then puick that row

if none of the above matches, move to next Client.

Only one row should be picked for any Client.

Any suggestions ?

topic Nested IF or Some Other Function ? in QlikView