5 Replies Latest reply: Feb 16, 2018 5:00 AM by Luis Carmona Martínez RSS

    QlikSense Total Percentage

    Luis Carmona Martínez

      I have the follwing graph created with 1 Measure and 2 Dimensions

       

      Measure

      Percentage of Clients

      Count(

      {< [Money]={">0"}>}

      distinct CLientNumber)

      /

      Count(

      {< [IMoney]={">0"}>}

      distinct TOTAL CLientNumber)

       

      Dimesion Money Rounded to 50

      Round ([MONEY],50)

       

      Dimension Store.

      StoreName

       

      The problem I have with that, is that there could be Clients that have paid 50 Euros, but also 80 Euros as well. This makes the Expression to fail, when calculanting this...

       

      Count(

      {< [IMoney]={">0"}>}

      distinct TOTAL CLientNumber)


      The formula (Above in Red) only counts the client One Time, and then the sum of the Percentages that comes from the Dimension Money sums more than 100%.


      What I need?

      - Percentage of Clients sums 100% for a particular shop, that is the sums of for every MONEY range percentage.

      - Preferable solution is that the Dimension, does not work for they MONEY payed in different transactions, rather than that for the SUM of all transactions for every client.