topic Re: Set Analysis Optimization in QlikView

Set Analysis Optimization

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

Is there any better way of writing the below set expression?

Sum({<Year={'2017'},Quarter={'Q4'}>}InsideSales)+Sum({<Year={'2017'},Quarter={'Q4'}>}WonSales)+Sum({<Year={'2017'},Quarter={'Q4'}>}LikelySales)+Sum({<Year={'2017'},Quarter={'Q4'}>}OutsideSales)

Re: Set Analysis Optimization

tresB — Thu, 19 Jan 2017 09:15:25 GMT

May be like:

Sum({<Year={'2017'},Quarter={'Q4'}>} Rangesum(InsideSales,WonSales,OutsideSales))

Re: Set Analysis Optimization

swuehl — Thu, 19 Jan 2017 09:16:29 GMT

Not sure how your model looks like and this could be important, but maybe

=Sum({<Year={'2017'},Quarter={'Q4'}>} RangeSum(InsideSales,WonSales,LikelySales,OutsideSales))

Re: Set Analysis Optimization

Anonymous — Thu, 19 Jan 2017 09:37:11 GMT

Thank you.It is working perfectly.