topic Re: Sum Total in Set Analysis in QlikView

Sum Total in Set Analysis

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

I have the below expression but How can I put that in set analysis ?

IF(_BTUnitOfMeasure = 'SQF',Sum(Total([RSF])),

Sum(Total([RSF])) * VarSfTOM2)

Thanks much.

sunny_talwar — Tue, 27 Sep 2016 16:37:39 GMT

May be like this:

RangeSum(

Sum(Total {<_BTUnitOfMeasure *= {'SQF'}>}[RSF]),

Sum(Total {<_BTUnitOfMeasure -= {'SQF'}>}[RSF]) * VarSfTOM2)

miguelbraga — Tue, 27 Sep 2016 16:38:33 GMT

You can make it something like this:

=Sum(Total {<_BTUnitOfMeasure = {'SQF'}>} ([RSF])) + Sum(Total {<_BTUnitOfMeasure -= {'SQF'}>} ([RSF])) * VarSfTOM2

Let me know if you got it right

Best regards,

D.A. MB

apthansh — Wed, 28 Sep 2016 02:04:27 GMT

Thank you.