Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Error

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

1 Solution

Accepted Solutions
struniger
Creator
Creator

This should work:

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


Good luck

Stefan

View solution in original post

5 Replies
struniger
Creator
Creator

This should work:

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


Good luck

Stefan

Not applicable
Author


Thanks!

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

Not applicable
Author

try this:

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

you cannot use an if in set Analysis.

regards,

MT

Anonymous
Not applicable
Author

Lucas

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

Not applicable
Author

Ok, but if I use a variable?

ex.:

SET vIf = (if statement)

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