Creating Linechart and Dotchart

Tue, 17 Nov 2015 13:49:10 GMT

Hello Community,

i'm new in the Qlikview Community.

I got the following data in an xlsx-sheet:

Time	Status	Variable	Value
Nov 06 2015 13:19:06.022.000		Variable_1	3.9
Nov 06 2015 13:20:06.010.032	Status_1
Nov 06 2015 13:21:06.100.056		Variable_1	4.5
Nov 06 2015 13:22:06.031.078	Status_2
Nov 06 2015 13:23:06.000.000		Variable_2	10.1
Nov 06 2015 13:23:07.022.032		Variable_2	2.3

What I want to do is, I want to import the xlsx-sheet an visualize the date in two charts.

1. The first chart show the variables vs. time in a linechart.

The x-axis show the timestamps of the table, the y-axis the value of the different variables.

When I use a time like 13:22:06 it works, but not with the timestamp of the xlsx-data. I got always "no numeric values on x-axis" in the chart.

2. The secont chart show the states vs. time

I have no idea how to do this. I need a chart with the timestamp on x-axis. On y-Axis there should be shown the Status.

When a status is in the table, there should be a dot or something else in the graph.

I would be great, if anyone have an idea, how to create this two charts. Regarding the code - i have only a personal licence.

topic Creating Linechart and Dotchart in QlikView