Discussion Board for collaboration related to QlikView App Development.
I have a dashboard that I am attempting Failure Rate % = Customer Feedback / Sales
So I have a Star Schema that does not have any Synthetic keys.
I am tracking Customer Feedback and Customer Sales
When I select Calendar fields I get only Sales data
Are the Date ID's in the same format - Yes
Is Customer Feedback and Sales linked - Yes (or as least as far as I can tell)
The part that gets me is that I can get an overall Failure by whatever I want - except Calendar
I have attached the QVW - I am looking for tips and tricks to find out where I have gone wrong - at this for a few days now and getting desparate.
Go to Solution.
Looking at the data in you QVW, The complaints are associated with MasterKey records that either do not have a DateID or the DateID is a timestamp.
View solution in original post
That was it, thanks Jerry, I adjusted the DateID and walllah
I appreciate the help