Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic aggregation

Hi guys,

I ask your help to solve a little big issue

I have a table like this:

Marker   Marker2   Data  Month ....

zee         zee         5

bfr         zee           7

tfr          gip           8

The list of Marker and of Marker2 is the same...and in my table I have a row for all the possible combination between Marker and Marker2.

Marker2 is a sort of aggregation of Marker.

In the presentation layer the user wants to choose which marker2 have to correspond to  a marker. IN other words Marker2 is an aggregation of Marker and the user wants to create this aggregation in the presentation layer dynamically.

P.S.

The number of Marker/Marker2 can change

Thanks

2 Replies
techvarun
Specialist II
Specialist II

Please explain the question in detail with full table structure and a example.


Regards

Not applicable
Author

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.

For example:

In the STANDARD simulation I calculate the exposure to risk for all the risk factor listed in marker field (bre, afr, gip)

Marker  Exposure

bre        10

afr         20

gip         5

In the AGGREGATED simulation I want to aggregate all in one row for the marker2 "bre" according to this choice:

marker  marker2

bre         bre

afr          bre

gip         bre

Attention: i would like to take this choice in the presentation layer.

Marker2  Exposure

bre           35

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