Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Anybody have an idea? Is this even possible in Qlik?