Mathematical operation on two alternate states with one common dimension

samme_89 — Fri, 23 Dec 2022 15:30:46 GMT

Hello,

First of all I don't even know if i know if I am on the right track here...

What i want to achieve is being able to have a generalized app for comparative calculation on multiple parameter values.
The user will use filters, for each state, to specify which parameter names with corresponding result.

I used this set expressions for the measures, which works just fine:

avg({<Result_number=p({Par1}Result_number)>}Result_number) / avg({<Result_number=p({Par2}Result_number)>}Result_number)

How ever I fail to add the product names a the dimension. Is there a possibility to create one "Parent" dimension which represents the two alternate states?

If this would be possible as we have tens of thousands of parameters in our databases with multiple mathematical operations needed, it's i a huge job to create all those needed individual charts.

Merry Christmas,

Samuel

Re: Mathematical operation on two alternate states with one common dimension

samme_89 — Mon, 09 Jan 2023 14:09:32 GMT

Anybody have an idea? Is this even possible in Qlik?

topic Re: Mathematical operation on two alternate states with one common dimension in App Development

Mathematical operation on two alternate states with one common dimension

Re: Mathematical operation on two alternate states with one common dimension