topic Re: Definition in Pareto in QlikView

Definition in Pareto

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

Dear all,

Can someone tell me whats wrong in this definition:

RangeSum(Above(Sum(Sum([Lengte])*[effective width]/1000),0,RowNo()))/Sum(TOTAL(Sum ([Lengte])*[effective width]/1000)

Thank you in advance!

Re: Definition in Pareto

rubenmarin — Fri, 19 Apr 2019 11:58:46 GMT

Hi, there are sum inside of sums, and divisor has more opened parenthesys than closed, try with:
RangeSum(Above(Sum([Lengte])*[effective width]/1000),0,RowNo()))/Sum(TOTAL [Lengte])*[effective width]/1000)

Re: Definition in Pareto

patricwessels — Fri, 19 Apr 2019 12:03:10 GMT

Thanks for your answer. I am sorry I wasn't more precise.

This one works:

RangeSum(Above(Sum([Afkeur MD (m2)]),0,RowNo()))/Sum(TOTAL([Afkeur MD (m2)]))

But the [Afkeur MD (m2)] needs to be replaced with:

Sum ([Lengte])*[effective width]/1000

And I can't get it working.

Re: Definition in Pareto

rubenmarin — Fri, 19 Apr 2019 17:38:37 GMT

How is Lengte and effective width related in data model? Maybe you can use applymap when loading data to have both fields multiplied and divided by 1000 when loading, using only one field would be like your initial expression.

I have reviewed my last expression and it has some dditional parenthesys, it should be:
RangeSum(Above(Sum([Lengte]*[effective width]/1000),0,RowNo()))/Sum(TOTAL [Lengte]*[effective width]/1000)

Or if its in another table with many values or concatenated to Lengte (not in the same row):
RangeSum(Above(Sum([Lengte])*Sum([effective width])/1000,0,RowNo()))/(Sum(TOTAL [Lengte])*Sum([effective width])/1000)

Or maybe, if effective widht is relateds to one value in another table:
RangeSum(Above(Sum([Lengte]),0,RowNo()))/Sum(TOTAL [Lengte])*[effective width]/1000

Re: Definition in Pareto

patricwessels — Tue, 23 Apr 2019 06:48:26 GMT

I have reviewed my last expression and it has some dditional parenthesys, it should be:
RangeSum(Above(Sum([Lengte]*[effective width]/1000),0,RowNo()))/Sum(TOTAL [Lengte]*[effective width]/1000)

This is it, thanks!