topic tamps? in QlikView

tamps?

xyz1 — Sun, 14 Apr 2019 11:05:54 GMT

asgardd2 — Fri, 20 Jan 2017 09:50:38 GMT

Hello!

You must have one field with date. (to show this in single chart)

You can do it like this (make new field 'type' and use this field in expression (set-analysis) on chart):

TempTable:

LOAD * INLINE [

Creation_Date, Accounted_for, Incident_ID

22.01.2016, 26.01.2016, 56465

19.01.2016, 29.01.2016, 56450

17.01.2016, 01.02.2016, 56400

10.02.2016, 15.02.2016, 58001

16.02.2016, 01.03.2016, 58050

];

NoConcatenate

DataTable:

LOAD

Creation_Date as Date,

Incident_ID,

'Creation' as type

Resident TempTable;

Concatenate(DataTable)

LOAD

Accounted_for as Date,

Incident_ID,

'Accounted_for' as type

Resident TempTable;

DROP TABLE TempTable;

MarcoWedel — Mon, 23 Jan 2017 23:32:41 GMT

Hi,

maybe helpful:

regards

Marco

rwunderlich — Mon, 23 Jan 2017 23:39:44 GMT

Also take a look at

-Rob