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: 
Avinash1
Contributor
Contributor

Load Fact Table With Dummy Data For Dimension

So the requirement is to load static values when we join a fact with dimension table in script for Qlik Sense.

The Fact data is one level higher that the Dimension Lookup table.

Ex:  for ID=A in Fact table, when joined with Dimension table, the data looks somewhat like below:

ID|COL1

1|A

1|B

1|C

So, when joined, the measures get multiplied by the number of rows present in COL1 in Dim table.

Users want only one combination to have valid records, and the rest to be populated with 0's.

Ex: below is how the final data should look post join.

ID|COL1|FCT

1|A|100

1|B|0

1|C|0

i have found a way to isolate the values with FirstValue() function in script, now i need to load the remaining two dimensions into the table.

 

Any help would be appreciated.

 

Thanks,

Avinash

0 Replies