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

# Ratio calc

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.

• ###### Re: Ratio calc

Hi,

Try this

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

Hope this helps you.

Regards,

jagan.

• ###### Re: Ratio calc

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

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

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

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.

• ###### Re: Ratio calc

The usage is in percentage calculation.and the result must be like ratio 2:1 like that.