topic Re: Compute % with 2 dimensions in QlikView

Compute % with 2 dimensions

tracycrown — Fri, 15 Nov 2024 22:17:24 GMT

Dear all

I have problem to compute **bleep** #SKU% after adding one more dimension (Category) in Table 2, please help urgently.

Note : I would like to get the same answer for **bleep** #SKU% #in Table 1.

Thank you, Tracy

Re: Compute % with 2 dimensions

anthonyj — Fri, 18 Mar 2022 01:33:54 GMT

Hi @tracycrown ,

I don't have Qlik View so I can't see your visualisation, but the calculation for percentages is:

Sum([Unit Sold])/Sum(total [Unit Sold])

The total function returns a single value which is the sum of [Unit Sold] ignoring all dimensions. To control which dimensions you want the total to take into account you add them between < >. So if you want to group the aggregation by Category you add the calculation like this:

Sum([Unit Sold])/Sum(total <Category> [Unit Sold])

I hope this helps.

Thanks

Anthony

Re: Compute % with 2 dimensions

tracycrown — Fri, 18 Mar 2022 02:30:26 GMT

Dear Anthonyj

Thank you for your quick response, please note that your suggestion does not solve the my problem.

Kindly refer to attached picture files below for details since you do not have Qlikview.

Thank you so much, Tracy

Re: Compute % with 2 dimensions

anthonyj — Sun, 20 Mar 2022 22:05:37 GMT

Hi @tracycrown ,

Thank you for the clarification it was a big help.

you can do a cumulative count in your table using the rangesum() and above() functions like this:

For the running count:

rangesum(above(Sum([Unit Sold]),0,rowno(total)))

And for the percentage:

rangesum(above(Sum([Unit Sold]),0,rowno(total)))/sum(total [Unit Sold])

I hope this fits your requirements but if you need anything further please ask.

Thank you

Anthony