Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Set Analysis Expression

Hello,

 

Please Help in Set Analysis Expression.

If(So_Bill_Balance > 0,

Sum(billQty))

How can i write in Set Analysis.

Labels (1)
2 Replies
Highlighted

Re: Set Analysis Expression

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
Highlighted
Digital Support
Digital Support

Re: Set Analysis Expression

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

Regards,
Brett

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.