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: 
sangeeth8787
Contributor III
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
prieper
Master II
Master II

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

sangeeth8787
Contributor III
Contributor III
Author

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