3 Replies Latest reply: Oct 19, 2015 3:23 PM by Yourinde Bauer RSS

    Dividing by the average of a distinct count in a straight table

      Hello everyone,

       

      It's very easy to construct the following straight table in Qlikview with the dimension YearMonth, expression count(distinct CustomerID) and

      I need to add a column which will divide the number of unique customers per month by the average. In Excel this is very simple:

      How do I create this column in Qlikview?