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

Running daily count of opoen cases

Hi

Our QA department need a summarized snapshot for the week showing

     A bar chart showing  the total cases opened and closed each day

     A line chart showing the running total of open cases at the end each day prefereably superimposed on the above bar chart

I have two problems   

      1) Using IntervalMatch the running totals (refer attached test qvw)  don't quite agree with the sample data  

      2) I can't get all three charts on the same chart - at least it would be good to get the daily opened and closed cases on the same chart

Help would be much appreciated

The actual data will be drawn from a large database - the Excel attached is just for illustration 

Regards Dave

1 Reply
jolivares
Specialist
Specialist

I think is good to take a look of this example, it can help you go to a great result for your application

http://www.qlik.com/us/explore/solutions/functions/it