Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sangeeth8787
New Contributor III

Dual Dimension Attritbute

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

 

 

 

 

2 Replies
Highlighted
prieper
Honored Contributor II

Re: Dual Dimension Attritbute

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

sangeeth8787
New Contributor III

Re: Dual Dimension Attritbute

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.

 

Dual Dimension example pic.PNG