2 Replies Latest reply: Nov 8, 2010 5:45 PM by John Witherspoon RSS

    how to get the number of same users we lose from previous period to the next period

      hi,

      I am trying to create a chart to measure how many same Qlikview users we lose from the previous month to the next month? The data I use is the qlikview log files.

      for example:

      The x-axix is month, the y axis is how many same users we lose from previous month to current month.

      if

      in month 1, we have 21 unique qlikview users.

      in month 2, we have 40 unique qlikview users, but only 11 unique qlikview users are same as in month 1.

      in month 3, we have 27 unique qlikview users, but only 20 unnique qlikview users are same as in month 2.

      then

      in month 2: we lose 10 unique users (=21 - 11).

      in month 3, we lose 20 qunique users (=40 - 20).

      I am trying to get the expression in the chart, not from the load part since I am trying to get the numbers change dynamicly when we do different selections in qlik.

      Is there anyway we can create a expression for this measure dynamicly ?? I've trying different ways, but still cannot find a solution. not sure if set anaylysis could help.

      could anyone help?

      thank you.