Two Lines on One Chart

[jmonroe918]

Attached is a qvw where I have two separate line charts showing:

Number of Closed Issues

Number of Opened Issues

Is it possible to get them both on the same chart?

Thanks

Jeff

[MarcoWedel]

Hi,

maybe helpful:

Canonical Date

regards

Marco

[HirisH_V7]

Hi Jeff,

Here You can create a applymap for your dates and make them into single field such that mapping with respect to Dimension and Expression occurs and thus will have View like Dual chart.

Regards,

hirish

[ecolomer]

Is that??

[MarcoWedel]

Hi,

maybe one solution could be also:

adding these lines to your script:

tabYrWk:
CrossTable(TypeTemp, [Yr/Wk])
LOAD [Issue Number],
     [Yr/Wk Closed],
     [Yr/Wk Originated]
Resident Issues;

Left Join (tabYrWk)
LOAD Distinct
  TypeTemp,
  SubField(TypeTemp,' ',2) as Type
Resident tabYrWk;

DROP Field TypeTemp;

hope this helps

regards

Marco