topic Re: Two Lines on One Chart in QlikView

Two Lines on One Chart

jmonroe918 — Fri, 23 Oct 2015 23:19:28 GMT

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

Re: Two Lines on One Chart

MarcoWedel — Sat, 24 Oct 2015 00:20:50 GMT

Hi,

maybe helpful:

Canonical Date

regards

Marco

Re: Two Lines on One Chart

HirisH_V7 — Sat, 24 Oct 2015 08:25:05 GMT

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

Re: Two Lines on One Chart

ecolomer — Sat, 24 Oct 2015 17:30:25 GMT

Is that??

Re: Two Lines on One Chart

MarcoWedel — Mon, 26 Oct 2015 00:06:46 GMT

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