Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Using multiple fields on 1 axis

Dear all,

I have a database like in the example. Now I would like to create a graph, showing the number of orders started in a given month AND the number of orders closed in a given month. An example of a graph is also given in the example below. Is there a way to combine the 2 fields (date started and date closed) for the x-axis? Or is there another easy way?test.png

2 Replies

Re: Using multiple fields on 1 axis

maybe helpful:

Canonical Date



Re: Using multiple fields on 1 axis

Another approach might be to match your started/closed dates with a master-calendar per IntervalMatch.

- Marcus

Community Browser