Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qliksense, two graphics in the same chart

Dears.

I want to create a table with the data below:

   

TicketTypeStart DateFinished Date
1AA25/04/2016
2BB25/04/2016
3CC25/04/2016
4BB25/04/2016
5BB26/04/2016
6BB26/04/2016
7BB26/04/201625/04/2016
8BB27/04/2016
9BB27/04/201625/04/2016
10CC27/04/2016
11BB28/04/201625/04/2016
12CC28/04/201625/04/2016

My idea is that in only one chart I can show how many tickets were created according to the "Start Date" field in accumulative way, and additional show how many tickets were finished according to the "Finished Date" field also in accumulative way, at the end the result is something like this:

Where the blue line is the chart of start date, and the red one is the chart of the finished date.

Is possible?

Thanks in advance.

BR

1 Reply

Re: Qliksense, two graphics in the same chart

It's possible but you need to transform you data so that you have only one date field instead of two.

CrossTable([Date Type], Date,2)

LOAD

     Ticket,

     Type,

     [Start Date],

     [Finished Date]

FROM

     ....source

     ;

You can then create a line chart with Date and [Date Type] as dimensions.


talk is cheap, supply exceeds demand
Community Browser