Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

11 Replies
Anonymous
Not applicable
Author

Any help?

Anonymous
Not applicable
Author

Some of the dates are pure dates and others a datetimes.

Converts all date to pure dates with statements like this :

    date(floor( [Resolve Date] ) as [SSR Resolve Date],

Anonymous
Not applicable
Author

Hi bill,

I want to know that why months are not coming for my "Service desk call Abandonment Rate" chart.

Thanks.

danieloberbilli
Specialist II
Specialist II

it seems there is no connection - you are using timestamps as your date fields...better clean/transform them as Bill suggested. So use e.g. date(floor(...   to get matching dates 

avinashelite

Hi Vijay,

As per my analysis, you don't have the data related to the STATUS value your checking for. Can you please share the xls file , lets have check

Anonymous
Not applicable
Author

Hi Daniel,

I already use  date(floor(... ) function.

Can you please explain me how can i get proper linking with composite key.

Thanks

danieloberbilli
Specialist II
Specialist II

just as example: in your table Sample Dump File:

You use [Resolve Date] to link to the calendar...but you dont use any Date(floor(  here

Anonymous
Not applicable
Author

Hi Daniel,

I did the correct as you said but still i dint get months as dimension.

Thanks

danieloberbilli
Specialist II
Specialist II

Could you upload your latest version again.

If the keys are ok, maybe you need to use MonthStart() instead of Month...but need to check