topic Re: Data is coming wrong or data model is wrong in QlikView

Data is coming wrong or data model is wrong

Anonymous — Wed, 06 May 2015 11:50:49 GMT

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

Re: Data is coming wrong or data model is wrong

Anonymous — Wed, 06 May 2015 12:06:14 GMT

Any help?

Re: Data is coming wrong or data model is wrong

Anonymous — Wed, 06 May 2015 12:29:23 GMT

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

Re: Data is coming wrong or data model is wrong

Anonymous — Thu, 07 May 2015 04:40:34 GMT

Hi bill,

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

Thanks.

Re: Data is coming wrong or data model is wrong

danieloberbilli — Thu, 07 May 2015 05:06:19 GMT

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

avinashelite — Thu, 07 May 2015 05:18:03 GMT

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

Re: Data is coming wrong or data model is wrong

Anonymous — Thu, 07 May 2015 05:18:48 GMT

Hi Daniel,

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

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

Thanks

Re: Data is coming wrong or data model is wrong

danieloberbilli — Thu, 07 May 2015 05:25:16 GMT

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

Re: Data is coming wrong or data model is wrong

Anonymous — Thu, 07 May 2015 05:37:03 GMT

Hi Daniel,

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

Thanks

Re: Data is coming wrong or data model is wrong

danieloberbilli — Thu, 07 May 2015 05:51:36 GMT

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

Re: Data is coming wrong or data model is wrong

Anonymous — Thu, 07 May 2015 06:10:18 GMT

PFA

Re: Data is coming wrong or data model is wrong

danieloberbilli — Thu, 07 May 2015 06:22:43 GMT

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.