Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Line Graph - 2 date fields as same dimension

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

3 Replies

Line Graph - 2 date fields as same dimension

Hi,

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

Celambarasan

Not applicable

Line Graph - 2 date fields as same dimension

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

Not applicable

Line Graph - 2 date fields as same dimension

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