topic Average data and minuets in Chart in QlikView

Average data and minuets in Chart

kstroupe — Wed, 26 Apr 2017 20:25:55 GMT

Hello,

I am trying to determine if cell phone usage is LOW for a time frame. I have a data load which has date, asset_id, data, minuets

In a straight table I was able to accomplished this with the following expression (The date time frame was chosen from a List Box):

=If(Avg(DataMB) <50 and Avg(Minutes) < 60 and status = 'ACTIVE' and Asset_Type = 'SMARTPHONE', 'LOW',If(Avg(DataMB) <50 and status = 'ACTIVE' and Asset_Type = 'IPAD', 'LOW',
If(Avg(Minutes) < 60 and status = 'ACTIVE' and Asset_Type = 'FLIP PHONE', 'LOW','OK')))

Asset_ID	Asset_Type	Both	Data	Min
12747	SMARTPHONE	OK	45	320
5180	SMARTPHONE	OK	2802.333333	863.3333333
8723	SMARTPHONE	LOW	0	0
2348	SMARTPHONE	OK	5105	906.3333333
24892	IPAD	LOW	0	0
0547	IPAD	LOW	0	0
4292	SMARTPHONE	LOW	43	40
0476	FLIP PHONE	LOW	0	0
281	FLIP PHONE	LOW	0	7.666666667
502	FLIP PHONE	OK	0	1292
518	FLIP PHONE	OK	0	247

I would like to create a chart which counts the "LOW" by Asset_Type

Any suggestions?

Thanks In Advance

Kim

Re: Average data and minuets in Chart

kstroupe — Wed, 26 Apr 2017 20:28:35 GMT

In this instance - The time frame was three months to Avg the data which was selected by a list box

Re: Average data and minuets in Chart

Digvijay_Singh — Wed, 26 Apr 2017 20:59:11 GMT

Something like this -

Count(if(Aggr(

If(

Avg(Data) <50 and Avg(Min) < 60 and Status = 'Active' and Asset_Type = 'SMARTPHONE', 'LOW',

If(Avg(Data) <50 and Status = 'Active' and Asset_Type = 'IPAD', 'LOW',

If(Avg(Min) < 60 and Status = 'Active' and Asset_Type = 'FLIP PHONE', 'LOW',

'OK'

)

),Asset_ID,Asset_Type)='LOW',Asset_ID))

Re: Average data and minuets in Chart

kstroupe — Wed, 26 Apr 2017 23:42:44 GMT

Thank you so much for your quick response that is exactly what I needed.

Re: Average data and minuets in Chart

Digvijay_Singh — Thu, 27 Apr 2017 01:05:42 GMT

I am glad it helped.