Set Anaylsis Question

Tue, 01 Sep 2009 14:36:31 GMT

Hi,

I tried this:

sum (if(User='John'),{<YTD_FPY={1},Year=>} Sales)

it's not working 😞

If I move the set analysis syntax before the if it works.

sum ({<YTD_FPY={1},Year=>} if(User='John', Sales))

Can someone please explain me why it has to be that way.

ps: I know that sum({<YTD_FPY={1},Year=, User={'John'}>} Sales) would be also an option.

Thanks

Matt

stephencredmond — Tue, 01 Sep 2009 17:43:00 GMT

Hi Matt,

It doesn't work because the result of the if:

{<YTD_FPY={1},Year=>} Sales

Doesn't stand as a valid result.

I would go with your last option - no point in mixing Ifs and sets when you can just use the set.

Stephen

topic Set Anaylsis Question in QlikView