Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor II

Graph sorting information based on 2 parameters

Hi everyone,

I am struggling to sort information in my graph. Easily said, i would like to use the excel function "Custom sort" to be able to sort:

1. with date ascending

2. with time ascending

I added some data in the excel attached and the graph I would like to display.

The major idea is to display material changes in the production. Each color is a material change on a given day on the produciton line.

The graph shows the dates on the horizontal axis correctly.

Unfortunately it doesnt follow the "hours timing" from each day.

What I would like is that the graph displays each material changes on its day with "time start" ascending (from starting time in the morning to evening).

Hope it is clear enough...

thanks a lot for your help