Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

leocattqv
Contributor

Calendar Help...

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.

Tags (1)
1 Solution

Accepted Solutions
jwjackso
Valued Contributor

Re: Calendar Help...

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

2 Replies
jwjackso
Valued Contributor

Re: Calendar Help...

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

leocattqv
Contributor

Re: Calendar Help...

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

I appreciate the help