Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Use chart dimension value in expression

Hi,

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
Person11
Person22
Person34
Person4Null
Person5Null

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?

Thanks ahead of time