topic Set Criteria in QlikView

Set Criteria

Mon, 19 Dec 2011 09:52:59 GMT

I am averaging a euro value across a variable defined set, in general this works well:

=Avg( {$<[Year]={$(varReportYear)}, [Code]={$(varTitleYear)}>} [Total Eur])

However, when I add a third variable which is string based; I get a result if the value is a single word e.g. "Brown" but don't if it contains spaces as in "Smith - London"

Any ideas would be helpfull.

Jim

Set Criteria

swuehl — Mon, 19 Dec 2011 11:36:58 GMT

Have you tried enclosing the string based variable in single quotes? Like

=Avg( {$<[Year]={$(varReportYear)}, [Code]={$(varTitleYear)}, [StringField] = {'$(varString)'} >} [Total Eur])

Set Criteria

Mon, 19 Dec 2011 12:44:35 GMT

Thank You, Spot On.