I am not sure if this is possible in QlikView, but I am wanting to use the value in a charts dimension, to evaluate in the expression to calculate retention.
So my data is showing number of people who started, and then how long the stayed a customer.
Example:
Person
StopAfterNumberOfMonths
Person1
1
Person2
2
Person3
4
Person4
Null
Person5
Null
Null means they are still a customer.
So what I would like to see is a line graph that shows the remaning customers I have over time.
So the after 1 month, I would have 4 customers
After 2 months, 3 customers remaining
After 3 months, 3 customers remaining
After 4 months, 2 customers remaining
So for the expression to count the number of customers I have left, I have a set expression similar to:
Sum( {$< CHANGE = {1} >}
if(
[StopAfterNumberOfMonths] >= (insert value of the time dimension here)
OR ISNULL([StopAfterNumberOfMonths])
, CHANGE
, 0
) )
So the chart knows that when it is showing data for Jan, it will put a 1 in the above set expression. If it is calculating Feb, it will put a 2 in the expression above.
Is there a way to do this using set expression or something else?
