Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
jduenyas
Specialist
Specialist

Set Analysis question

Hi All

What is the difference between these to statement? :

sum({<OrderedTotal = {"<>0"}>}OrderedTotal)

sum({<OrderedTotal -= {0}>}OrderedTotal)

And which is correct?

(The returned results are different)

Thanks

3 Replies
sunny_talwar

Without selection, both should give you the same result, but will give different results based on user selection in OrderedTotal field.

sum({<OrderedTotal = {"<>0"}>}OrderedTotal) -> no impact with selection in OrderedTotal

sum({<OrderedTotal -= {0}>}OrderedTotal) -> will show everything in your current selection except 0 when you select something OrderedTotal.

jduenyas
Specialist
Specialist
Author

Thanks

sunny_talwar

Not a problem