Dual Dimension Attritbute

sangeeth8787 — Thu, 21 Feb 2019 10:55:13 GMT

Hi,

I have two fact tables and three dimensions

Fact A Table

ColorKey

DateKey

LocationKey

coalesce(FactaColor,AnotherColumnFromFactATable) as Color

Sales

Fact B Table

ColorKey

DateKey

LocationKey

Sales

Amt

Dimensions

Dim_Color

Dim_Date

Dim_location

I have special requirement, where In Pivot Table chart, I need to use attribute/column from fact table A (here color column), but in the same chart, I need to bring measures from Fact A and Fact B.

I have created link table for Fact A and Fact B with three dimensions with common key column, I can create Pivot chart with multiple measure from A and B table, if I Choose Dimension column from Actual Dimensions table, but for my new requirment, I had to choose column Colour from Fact A Dimension instead of DIM_Colour.

I am looking to achieve something like

Sum({<FactA.ColourColoum.Fieldvalues = DimensionTable.ColourColum.FieldValue , Location= {'UK'}>}Sales)

This (FactA.ColourColoum) column is chosen in Pivot-chart Dimension

I am not sure whether is it possible or not. Could any have ideas, could you please share thoughts about it.

Many Thanks

Re: Dual Dimension Attritbute

prieper — Tue, 26 Feb 2019 08:38:50 GMT

would make sense to post an example with the data and the required output

Re: Dual Dimension Attritbute

sangeeth8787 — Tue, 26 Feb 2019 09:14:59 GMT

Hi,

To make it simplify, I have 4 fact tables and 6 dimensions, For one Pivot chart I had to use dimension attribute from Fact table instead of Dimension table.

topic Dual Dimension Attritbute in QlikView

Dual Dimension Attritbute

Re: Dual Dimension Attritbute

Re: Dual Dimension Attritbute