Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mr_novice
Creator II
Creator II

Process visualization over time

Hello all!

I have a very simple process where items are in different status over time. I have visualised the current status and amount in a table as below. Very simple. Now, I need to show how these statuses have changed over time and I don't want to create a table for each day in history... So how do you suggest this can be displayed in the best way?

Sparklines in the "current" table? - Comparison would be difficult.

Trendline chart with amount on Y-axis, time on x-axis and status as dimension?

Any other suggestion?

Br

Cris

Current:

Status1Status2Status3Status4Status5
200300502010

Yesterday:

Status1Status2Status3Status4Status5
100400258090
1 Solution

Accepted Solutions
marcarreras
Specialist
Specialist

Hi,

If you need to see both amount and compare to yesterday, you can make like this:

chart.jpg

Does it fit for you?

Marc.

View solution in original post

8 Replies
alexandros17
Employee
Employee

I think that line chart is the best idea ... Time and Values on axis.

marcarreras
Specialist
Specialist

Hi,

If you want to compare status volume in two different times, I would try to work with incremental values in a bar chart with status as dimension.

Marc.

mr_novice
Creator II
Creator II
Author

Thank you Alessandro. Thats my best alternative right now.

mr_novice
Creator II
Creator II
Author

Hi Marc,

What do you mean by incremental values on a bar chart? - One bar per status and amount on the y-axis? Should I use a stacked bar chart to show the values for different time? the x-axis would be status and time? or time and status?

Sorry for all questions.

Br

cris

marcarreras
Specialist
Specialist

Hi,

I meant something like this:

chart.jpg

If you want to compare current and yesterday, the incremental display will be fine. Otherwise, if you need to analize the current amount, use bar chart with total amounts.

Hope it helps.

Marc.

marcarreras
Specialist
Specialist

Hi,

If you need to see both amount and compare to yesterday, you can make like this:

chart.jpg

Does it fit for you?

Marc.

marcarreras
Specialist
Specialist

Hi,

Did it help? If yes please close thread by selecting correct answer.

Marc.

mr_novice
Creator II
Creator II
Author

Gracias. It did help and I forgot to close the thread.

Br

Cris