Ok...I will try...
My goal is to calculate the exposure to risk (in terms of money) of my sales of raw materials.
The risk is due to a series of risk factors (=marker). For example the USD rate, the price of Brent (marker=bre) and so on...
I would like to perform two kind of simulations: STANDARD and AGREGATED. This last according to two kind of calculation methods: RATIOS and SPREAD.
This aggregated simulation is my problem. I called it "AGGREGATED" because I want to calculate the exposure aggregating my markers (risk factor) in marker2.
In my datasource (I have only one table) I have a row for each combination of marker and marker2 but I don't want to use all the combination but only those I choose in presentation layer.
In the STANDARD simulation I calculate the exposure to risk for all the risk factor listed in marker field (bre, afr, gip)
In the AGGREGATED simulation I want to aggregate all in one row for the marker2 "bre" according to this choice:
Attention: i would like to take this choice in the presentation layer.
In my datasource I have all the possible combination of marker and marker2 with the relative exposure
I attach my qlik app.
It's very difficult for me to explain my work but please try to help me.
thanks a lot