Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vijayptcs
New Contributor III

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
vijayptcs
New Contributor III

Re: Data is coming wrong or data model is wrong

Any help?

Re: Data is coming wrong or data model is wrong

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],

vijayptcs
New Contributor III

Re: Data is coming wrong or data model is wrong

Hi bill,

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

Thanks.

danieloberbilli
Valued Contributor II

Re: Data is coming wrong or data model is wrong

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 

Re: Data is coming wrong or data model is wrong

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

vijayptcs
New Contributor III

Re: Data is coming wrong or data model is wrong

Hi Daniel,

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

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

Thanks

danieloberbilli
Valued Contributor II

Re: Data is coming wrong or data model is wrong

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

vijayptcs
New Contributor III

Re: Data is coming wrong or data model is wrong

Hi Daniel,

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

Thanks

danieloberbilli
Valued Contributor II

Re: Data is coming wrong or data model is wrong

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

Community Browser