Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
As the title says, I am trying to create a line chart that has data representing the separate counts but they are overlapping.
My data set has two relevant dates: Dates submitted and dates completed. Each line item has a value for each date. Because my workplace bases its reporting off of work complete, that is the dimension I set for the chart (so the x axis timeline scale is showing "Date Complete" which drills down Year(, Month(, and Day(). My Expressions are =count([Date Submitted]) and =count([Date Complete]).
The lines are overlapping. I think this is because it is giving me the count based on the date closed, which would obviously be equal since there is a value in each. I want so show the spread for months/days, however. So on 1/1/2017 there may be 10 created, but only 5 completed, or something like that.
This is probably just me being new to Qlikview; hopefully an easy fix, but I can't figure it out.
Thanks!
Message was edited by: Tyler Tollin
I think you need this
And use the master date as your dimension and then use the Closed and Submitted flags to show the two different lines
Can you share a sample app to look into?
Added
I think you need this
And use the master date as your dimension and then use the Closed and Submitted flags to show the two different lines
Marked as correct. It took some time to figure out, but this has produced the correct result.
Thanks Sunny.