topic Re: Set Analysis question in QlikView

Set Analysis question

jduenyas — Mon, 12 Oct 2015 23:47:53 GMT

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

sunny_talwar — Tue, 13 Oct 2015 00:15:34 GMT

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 — Tue, 13 Oct 2015 00:22:33 GMT

Thanks

sunny_talwar — Tue, 13 Oct 2015 00:23:48 GMT

Not a problem