If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi, i have the following data
A 01/01/21B 01/04/21C 01/04/21
In another table i have Dept against a number of rows of data, e.g.
Dept HostA Host1A Host2A Host3B Host4
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
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))