Discussion Board for collaboration on QlikView Scripting.
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.
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],
I want to know that why months are not coming for my "Service desk call Abandonment Rate" chart.
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
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
I already use date(floor(... ) function.
Can you please explain me how can i get proper linking with composite key.
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
I did the correct as you said but still i dint get months as dimension.
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