topic Re: Evaluate If statment within Set Analysis in QlikView

Evaluate If statment within Set Analysis

robert_mika — Thu, 22 Dec 2016 16:56:15 GMT

I hit a brick wall

I would like evaluate if statement within set analysis.

When creating variable I can write:

v_Co

=If(.....

and I can use that within my set analysis

SUM( {$<Desc={'$(v_Co)'}>} Am)

but how to write the set analysis syntax to evaluate that if statement in set analysis only.

I do not want to use variable globally.

so the when crating variable I will use:

v_Co

if(......

(no equal sign)

MK_QSL — Thu, 22 Dec 2016 16:58:01 GMT

SUM( {$<Desc={'$(=$(=v_Co))'}>} Am)

robert_mika — Thu, 22 Dec 2016 17:01:41 GMT

I swear I tried that.

Thank Manish!

Vary Merry x-mass!