Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-05-06 07:50 AM

Data is coming wrong or data model is wrong

Hi All,

When i am creating data modelling i got difficulties to link  3 table with composite key and i think my linking is not proper.

can you please check and validate.

When i am creating reports month is not coming.


PFA

Community.qvw
1,014 Views
0 Likes
11 Replies
Anonymous
Not applicable
‎2015-05-07 02:10 AM
Author

In response to danieloberbilli

PFA

Community.qvw
169 Views
0 Likes
danieloberbilli
Specialist II
Specialist II
‎2015-05-07 02:22 AM

In response to Anonymous

You have to reconsider your keys:

Your table Sample Calls Dump is linked by Agency & Date to Sample Dump File

Your chart expression limits the data to {<Status={'Lost ACD'}>}

As you see in the tables: there are only two cases: both at the 28/03/2015

BUT: in your linked table (that is between your first and the calendar table) there is no date 28/03/2015 - not for Agency 1, nor for any other...so there is no linkage to your calendar.

169 Views