Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
DMG
Contributor III
Contributor III

Rundown Line Chart

Hi, i have the following data

Dept Target_Date

A 01/01/21
B 01/04/21
C 01/04/21

In another table i have Dept against a number of rows of data, e.g.

Dept   Host
A       Host1
A       Host2
A       Host3
B       Host4

etc

I would like to plot a line chart going from the total of all hosts then down over time as it hits each date field, e.g.

at the 01/01/21 mark on the line chart it would count all hosts in A B and C

at the 01/04/21 mark the A set no longer applies so i'd like the line to just represent the total hosts in B and C at that point

 

Hope that makes sense

1 Reply
GaryGiles
Specialist
Specialist

With Target_date as your dimension, you could use Count(Total . . .) and the RangeSum()  functions to create a Rundown calculation in your measure like this:

count(Total Host) - RangeSum(Above(count(Host),1,10000))