topic add calculated dimension into table mapping in QlikView

add calculated dimension into table mapping

Mon, 27 Aug 2012 05:17:45 GMT

Hello Guys,

I have the following Problem.

I want to add an calculated column to an existing table, and connect this table, using this calculated column as key, to another table.

ID	Type	Markup Class (calculated)
100001	XY	1
100002	YX	2

Markup Class (non calculated)	Markup factor
1	1,1
2	1,2

Is there a way to do this?

Is it only possible within the Load Skript?

Hope someone knows how to solve this...

Regards

Kilian

its_anandrjs — Mon, 27 Aug 2012 05:22:47 GMT

Hi,

Yes it is possible but on the basis of which fields you want to calculated and generate a column. Please explain clearly.

Thanks & Rgds

Mon, 27 Aug 2012 05:47:17 GMT

Those again are different fields. Maybe this makes it clearer:

Now I caculate the Final Application Class like this:

Round((SUM([Application Weight]* [Application Class])) with HCID as Dimension.

Now I want to map the until now unmapped Final Application Class Table on the upper right on this basis, to get a markup factor.

This markup factor I will use for further calculations.

i could solve this one in excel easliy, but I want to do all calculations in QlikView.

Mon, 27 Aug 2012 11:09:00 GMT

Need more info?