topic Re: set analysis in QlikView

set analysis

Tue, 03 Sep 2013 14:41:10 GMT

Hi,

I was wondering if instead of doing:

sum($<Region={America}>} Sales)

could I do:

sum($ upper(Region)={AMERICA}>} Sales) ?

jpapador — Tue, 03 Sep 2013 14:45:26 GMT

You would have to do that in the load script. I don't think it lets you use commands like that in set analysis.

Oleg_Troyansky — Tue, 03 Sep 2013 14:48:30 GMT

Eric,

no, this would not be correct. Set Modifiers should always look like the following:

Field = {.... } - the = sign might be replaced by other signs, but the Field name should remain there "as is".

You can, however, use the search functionality and express your condition as part of the search:

sum({$<Region ={"=upper(Region)='AMERICA'"}>} Sales)

Notice the double quotes signifying the search condition and the equal sign in front of the search condition.

Oleg Troyansky

Tue, 03 Sep 2013 16:18:00 GMT

thanks!