Calculate most restrictive value

Terratorterry — Sat, 16 Nov 2024 20:17:15 GMT

Hello, I’d like to know how to make this output in this table taking those booleans into account for making the restriction condition.

If boolean is 0 in any row this code has to be discarded.

The logic explained is similar to this: [1,1,1,1] & [1,1,0,0] & [1,1,1,0] & [6656, 6657, 6658, 6659] = [6656, 6657, 0, 0]

Table;

Desired output;

Tried with If(sum(aggr(sum(aggr(sum(Boolean),Code,Category)),Category))=sum(aggr(sum(aggr(max(sum(Boolean)),Code,Category)),Category)),1,0)

Re: Calculate most restrictive value

Brett_Bleess — Wed, 28 Aug 2019 12:45:18 GMT

Borja, in these cases, it generally helps get responses if you can attach the app or a sample app with the issue, so folks can look at things in much greater detail.

Regards,
Brett

topic Calculate most restrictive value in QlikView

Calculate most restrictive value

Re: Calculate most restrictive value