Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dathathreya
Contributor

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.

thanks in advance.

1 Solution

Accepted Solutions
MVP
MVP

Re: Ratio calc

Hi,

Try this

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

Hope this helps you.

Regards,

jagan.

6 Replies
MVP
MVP

Re: Ratio calc

Hi,

Try this

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

Hope this helps you.

Regards,

jagan.

bellamae
Valued Contributor

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.

dathathreya
Contributor

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.

dathathreya
Contributor

Re: Ratio calc

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

MVP
MVP

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.

dathathreya
Contributor

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