topic Re: Dynamic aggregation in QlikView

Dynamic aggregation

Wed, 24 Jul 2013 10:27:21 GMT

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

Re: Dynamic aggregation

techvarun — Wed, 24 Jul 2013 10:31:59 GMT

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

Regards

Re: Dynamic aggregation

Wed, 24 Jul 2013 11:45:12 GMT

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