6 Replies Latest reply: Feb 22, 2017 12:19 AM by Datha Raja RSS

    Ratio calc

    Datha Raja

      Hi all i am new to qlik plz help me in ratio calc part.

      i have a table like usage.i ahve fields like cust_id,usage.table contains 100 records .every customer have 70% of limit of usage.but some of the customers will exceed the limit.now i want to get how many customers exceed the limit in ratio.

      thanks in advance.

        • Re: Ratio calc
          jagan mohan rao appala

          Hi,

          Try this

           

          =Count({<UsageLimit={'>0.7'}>}DISTINCT Customer)

           

          Hope this helps you.

           

          Regards,

          jagan.

            • Re: Ratio calc
              Datha Raja

              Thanks for ur reply but i want to get it in ratio 70 is not amount it is percentage.for percentage how can we get ratio.

                • Re: Ratio calc
                  jagan mohan rao appala

                  Can you share some sample data and your expected output, it helps in understanding the data and provide the solution.

                   

                  Regards,

                  Jagan.

                    • Re: Ratio calc
                      Datha Raja

                      Hai Jagan Mohan,

                       

                      Below is the sample data of broadband wifi.let assume of 100 records in the table and fields are.here ssid is the router and ssid have saperate line capcity in the area which they cover.so here i want to get (Avg active connections per hour,%of users exceeding limit of 70%,peek time of wiki usage)

                      ssid  Payment_Method   Wifi_Associations  Wifi_Connections  Line_Capacity  Peek_Tp sessiontime

                      1                     master                   150                      130                        60gb              70%          30mns

                      2                        visa                     120                      100                        70gb              80%             20mns

                      3                       credit                    100                       80                         40gb               90%            50mns

                • Re: Ratio calc
                  Bella Mae

                  is you usage a percentage or amount? if it is an amount you will need to turn it into a percentage to use the expression Jagan has provided.