Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
samme_89
Contributor II
Contributor II

Mathematical operation on two alternate states with one common dimension

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)

 

samme_89_0-1671805750665.png

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

Labels (1)
1 Reply
samme_89
Contributor II
Contributor II
Author

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