topic Line Graph - 2 date fields as same dimension in QlikView

Line Graph - 2 date fields as same dimension

Fri, 02 Mar 2012 09:48:57 GMT

Hi All,

I have 2 tables - one with date, type and value, the other with month and % (actual and target respectively).

I can use monthname(date) to get the date to match the month, but is there a way to link the two as a dimension?

Basic layout of my chart is sum(value) by month (full accumulation) as one line, cumulative % by month as another. As the target is only given in months, there isnt an exact date to match against. I've not got my heart set on line so if this can be done as bar or mixed I am happy to change...

Thanks for any insight.

Lee

Line Graph - 2 date fields as same dimension

CELAMBARASAN — Fri, 02 Mar 2012 10:29:37 GMT

Hi,

You should have create the month field in the Load script.

Celambarasan

Line Graph - 2 date fields as same dimension

Fri, 02 Mar 2012 13:35:09 GMT

Hi,

Do you mean in the load script have monthname(date) as target_month and then load the target month as target_month, thus linking the two?

That sounds like ti should work - only basing the chart on one field which is shared by both tables. Genius!

Thanks Celambarasan

Lee

Line Graph - 2 date fields as same dimension

Fri, 02 Mar 2012 14:06:13 GMT

Ok, new problem.

I now need to find the difference between two dates (easy), but I need to calculate this within the load script. If the two dates are on seperate tables, can this be done?

Thanks