topic Re: Data Modelling Question in QlikView

Data Modelling Question

Anonymous — Thu, 28 Apr 2016 06:14:10 GMT

I have 2 tables Weekly Metrics and Metric Definitions tables , I want Target and Bridge value from Metric Definitions table into Weekly Metrics Table , the common field between these 2 tables are User Friendly Metric Name ( From Metrics definitions) and Category (from Weekly Metrics) tables.

There is 1 Target and 1Bridge value for each of the User Friendly Metric Name , I need to get those values displayed in Weekly Metrics table for same Category .. how do I achieve this?

Expected output should be something as below,

CLNDR_DT	Category	Data	Bridge Value	Target Value
4/22/2016	FCI TOP 50	20	45	50
4/15/2016	FCI TOP 50	30	45	50
4/8/2016	FCI TOP 50	15	45	50
4/1/2016	FCI TOP 50	40	45	50
3/25/2016	FCI TOP 50	12	45	50

Attached is my app

Thank you

Re: Data Modelling Question

sunny_talwar — Thu, 28 Apr 2016 10:06:54 GMT

I don't see FCI TOP 50 under the category field. Have you attached the correct qvw file?

Re: Data Modelling Question

Anonymous — Thu, 28 Apr 2016 14:59:23 GMT

Yes , it actually there in the Metrics Definition Table , please find the File again .. I have saved it .. so I want all values in Metric definitions tables and its related Bridge and target values

Re: Data Modelling Question

sunny_talwar — Thu, 28 Apr 2016 15:13:22 GMT

I guess I don't really understand your data and having difficulty understanding the relation between the two fields and how are you hoping to see just that particular value. Can you elaborate on the logic?

Re: Data Modelling Question

Anonymous — Thu, 28 Apr 2016 15:21:24 GMT

Sorry ... the value I have is just an example value , if you look into the data model .. I want to get Target Value and Bridge Value in Metrics_Definitions table into Weekly Metrics , there is a Category column in Weekly Metrics table which is same as User Friendly Metric Name in Metrics Definitions , so for all category values that match with User Friendly Metric Name, I want Target and Bridge values from Metrics_Definitions table .

Re: Data Modelling Question

Anonymous — Thu, 28 Apr 2016 17:57:03 GMT

Used Apply Map function to get Bridge and Target based on User friendly metric name and it worked.

Thank you!

Re: Data Modelling Question

sunny_talwar — Thu, 28 Apr 2016 17:58:22 GMT

Great, I am glad it all worked out in the end.