topic Calendar Help... in QlikView

Calendar Help...

leocattqv — Tue, 20 Feb 2018 19:38:25 GMT

Hi all,

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.

jwjackso — Tue, 20 Feb 2018 19:52:47 GMT

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.

leocattqv — Tue, 20 Feb 2018 21:51:11 GMT

That was it, thanks Jerry, I adjusted the DateID and walllah

I appreciate the help