Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Set Analysis Expression



Please Help in Set Analysis Expression.

If(So_Bill_Balance > 0,


How can i write in Set Analysis.

Labels (1)
2 Replies

Set analysis is a filter, not a conditional, so you cannot implement if(...sum()) type expressions using set analysis.

If what you really meant was

Sum(If(So_Bill_Balance > 0, billQty))

which is not the same thing, then this could be done using:

Sum({<So_Bill_Balance = {">0"}>}   billQty))


Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Digital Support
Digital Support

See related post: https://community.qlik.com/t5/QlikView-App-Development/Help-Set-Analysis-Expression/m-p/1679688#M449...


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.