topic Set Analysis Error in QlikView

Set Analysis Error

Tue, 25 Feb 2014 12:22:00 GMT

Hi,

I have been trying to get this expression for my chart, but it hasn't worked:

sum({<if(FeedbackTime<0,'0',FeedbackTime)>}FeedbackTime)

I get a "Error in set modifier expression" error.

Thanks in advance for your help,

Lucas

struniger — Tue, 25 Feb 2014 12:26:08 GMT

This should work:

sum(if(FeedbackTime<0,0,FeedbackTime))

Good luck

Stefan

Tue, 25 Feb 2014 12:27:49 GMT

Thanks!

Could you try to tell me why mine didn't work?

Tue, 25 Feb 2014 12:28:12 GMT

try this:

sum(if(FeedbackTime=>0,FeedbackTime))

you cannot use an if in set Analysis.

regards,

Anonymous — Tue, 25 Feb 2014 12:29:07 GMT

Lucas

"if" is not valid within a set analysis expression.

Tue, 25 Feb 2014 12:32:58 GMT

Ok, but if I use a variable?

ex.:

SET vIf = (if statement)

sum({<(if statement)>}FeedbackTime)