topic Re: Calculating % Mix for two separate categories within one dimension in App Development

Calculating % Mix for two separate categories within one dimension

lruffin76 — Tue, 03 Jan 2023 15:17:29 GMT

Hello,

I am looking for help with a formula to calculate my % mix of RO Count (Measure) within two categories of one dimension. You will see in the screen shot that I have a dimension field that sorts vehicle makes into two categories, Luxury and Non-Luxury. I am wanting to calculate % mix of RO Count for each vehicle make within it's own category, not for the overall total.

Any help is greatly apprecaited!

Re: Calculating % Mix for two separate categories within one dimension

vinieme12 — Wed, 04 Jan 2023 08:41:19 GMT

You can can achieve that using the TOTAL Keyword in your aggregation function

example

=sum(Sales)/Sum(TOTAL <Department> Sales)

incase of multiple dimensions

=sum(Sales)/Sum(TOTAL <Department,Store> Sales)

refer

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Examples%20of%20Aggregate%20Qualifiers.htm

Re: Calculating % Mix for two separate categories within one dimension

lruffin76 — Wed, 04 Jan 2023 14:51:53 GMT

Hello, this didn't work for me. If it helps, here is an excel example of what I am needing.

Re: Calculating % Mix for two separate categories within one dimension

jbhappysocks — Wed, 04 Jan 2023 15:35:27 GMT

You need to add Luxury/Non-Luxury as a dimension in you load script instead of having it as a calculated dimension in the table. Then you will be able to use the suggested solution, something like this:

=count(RO)/Count(TOTAL <YourNewDimension> RO)