topic nested set analysis in QlikView

nested set analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

could you please let me know how to include set analysis in another one?

lets say i need to have sum({<Flag1={1}, sum(Costs)<>0 >} Sales)

I'm not sure how to surround the sum(Costs)<>0 with brackets and apostrophes.

Many thanks in advance

Tommy

sunny_talwar — Thu, 08 Sep 2016 15:28:36 GMT

May be like this:

Sum({<Flag1 = {1}, OrderID = {"=Sum(Costs) <> 0"}>} Sales)

Here OrderID is the field where you want to check if Sum(Cost) <> 0 or not. You might need to use another field based on your requirement