conditionnal sum

sunnybi — Wed, 19 Feb 2025 21:15:47 GMT

Hi Experts ,

Once again I need your help ! the case may look simple but I can't have the expected results .

In expression D ,in the table below , I'd like to have the total where expression C < 39.

As you can see , the columns 2 and 3 in the expression D are excluded which is correct , but still haven't found out why the total don't show up. I tried to sum (aggr ( D expression,... ) but still.

the results is ok , in a straight table : (had to change total properties from auto to Sum )

Thank you thousand time for your help

Re: conditionnal sum

Clement15 — Thu, 20 Feb 2025 09:57:14 GMT

Hello,

You must use a formula of this form

sum( {<Dimension={"=sum(Measure)<39"}>} Measure)

topic conditionnal sum in QlikView

conditionnal sum

Re: conditionnal sum