topic Re: how to find cpu usage at max date in QlikView

how to find cpu usage at max date

Fri, 07 Nov 2014 02:47:48 GMT

Hello every one. i am trying to find cpu usage at max date. The dimensions are Host_name, Blade_name. i am expecting to see in bar chart.

1.05 (last row)

Date	cpu-0
10/3/2014 7:00	1.13
10/3/2014 9:00	1.16
10/3/2014 11:00	1.16
10/3/2014 13:00	1.17
10/3/2014 15:00	1.19
10/3/2014 17:00	1.16
10/3/2014 19:00	1.15
10/3/2014 21:00	1.11
10/3/2014 23:00	1.07
10/4/2014 1:00	1.04
10/4/2014 3:00	1.04
10/4/2014 5:00	1.06
10/4/2014 7:00	1.10
10/4/2014 9:00	1.15
10/4/2014 11:00	1.17
10/4/2014 13:00	1.17
10/4/2014 15:00	1.17
10/4/2014 17:00	1.16
10/4/2014 19:00	1.14
10/4/2014 21:00	1.11
10/4/2014 23:00	1.07
10/5/2014 1:00	1.05
10/5/2014 3:00	1.04
10/5/2014 5:00	1.04
10/5/2014 7:00	1.09
10/5/2014 9:00	1.14
10/5/2014 11:00	1.16
10/5/2014 13:00	1.17
10/5/2014 15:00	1.16
10/5/2014 17:00	1.15
10/5/2014 19:00	1.12
10/5/2014 21:00	1.09
10/5/2014 23:00	1.05

Thanks for your help.

Re: how to find cpu usage at max date

Fri, 07 Nov 2014 04:44:24 GMT

Try:

test:

load

FirstSortedValue(cDate,-cDate) as cDate,

FirstSortedValue(cpu,-cDate) as cpu;

LOAD date(date#(cDate, 'MM/DD/YYYY hh:mm'),'MM/DD/YYYY hh:mm') as cDate, cpu INLINE [

cDate, cpu

10/5/2014 15:00, 1.16

10/5/2014 17:00, 1.15

10/5/2014 19:00, 1.12

10/5/2014 21:00, 1.09

10/5/2014 23:00, 1.05

];

Hope this was helpful.

Thanks,

Singh

Re: how to find cpu usage at max date

sujeetsingh — Fri, 07 Nov 2014 05:03:58 GMT

Angad have given the best way well you can calculate it by grouping and taking max date in script.

Re: how to find cpu usage at max date

Fri, 07 Nov 2014 05:15:06 GMT

Thanks a lot Sujeet, coming this from you really means a lot

Re: how to find cpu usage at max date

Fri, 07 Nov 2014 13:39:42 GMT

if i calculate the max date in a script and load the data. How it will work if the user pick a different date from a list box. May be let me rephrase my question, i see there are two things here:

1. by default show cpu utilization for max date.

2. show cpu usage for a selection day/ week / month by blade.

Re: Re: how to find cpu usage at max date

anbu1984 — Fri, 07 Nov 2014 13:59:37 GMT

Check this app