Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Chris272727
Partner - Contributor
Partner - Contributor

Estimated vs Actual Trend line in a Bar chart

I would like to show TUTEstimatedDate vs TUTActualCompletionDate in a line chart graph. Attached sample line chart

 

 

TUTEstimatedDateTUTStatusTUTActualCompletionDate
5/17/2020Completed5/18/2020
5/20/2020Completed5/21/2020
5/23/2020Completed5/23/2020
5/25/2020Completed5/27/2020
5/28/2020Completed5/30/2020

 

 

Labels (2)
1 Reply
eliran
Creator III
Creator III

Hi,

I'm not sure how you want to use the data else in the model, but to reach the above chart, you need to get to a unified dimension (x axis).

I would manipulate the data  a bit, split the rows into estimations, and completed rows.

In the chart, build two expressions

=count({<[Estimate / Complete]={'Estimate'}>}Date)

=count({<[Estimate / Complete]={'Complete'}>}Date)

with one dimension - Date

 

Below is a suggesion for the final table

DateEstimate / Complete
5/17/2020Estimate
5/20/2020Estimate
5/23/2020Estimate
5/25/2020Estimate
5/28/2020Estimate
5/18/2020Completed
5/21/2020Completed
5/23/2020Completed
5/27/2020Completed
5/30/2020Completed

 

* it is not best practice to build flags based on text, you can just transform it to numbers, but it was just to showcase the solution

 

I hope it helps,

Eliran.