Ratio calc

[dathathreya]

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.

[jagan · Accepted solution]

Hi,

Try this

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

Hope this helps you.

Regards,

jagan.

[Anonymous]

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.

[dathathreya]

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.

[dathathreya]

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

[jagan]

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

Regards,

Jagan.

[dathathreya]

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