Discussion Board for collaboration related to QlikView App Development.
i have one fact table and various Dimension tables linked by ID.
I need to derive a new column in fact table based on the values from different dimension tables.
if the corresponding id is not present in the Dimension table then put a default value in the derived Column.
Can someone help me find the solution for the above scenario.
One way would be to create/use a mapping table.
After loading your Dimension_Table_1 perform a Mapping Load with using the ID and "Dimension A":
Then while loading your Fact apply the map
ApplyMap('DimensionA_Map', ID, 'default value') as [Dimension A in Fact table] //If ID doesn't exist in the Map it will populate the value in the 3rd param
For more info about the Apply map see
Don't join - use Applymap instead
Please elaborate your requirement a bit more i.e. what exactly you want to derive??.
You can use exists function to check the same but that depends on the logic you want to apply.
Load All Dimension tables first then,
IF(Exists(Dim_ID), yourLogic, 'Default value' ) as DerivedColumn
From FactTable ;
Please refer to the below link for the actual requirement.
Re: How to create a data set.