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.
Solved! Go to Solution.
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