topic Re: Need Help in QlikView

Need Help

Wed, 25 Nov 2020 16:16:04 GMT

@I need to find out how many server having windows OS are having average of usage above 45 .

Server	OS	Date	Usage
A	Windows	5/20/2016	40
B	Windows	5/20/2016	21
C	UNIX	5/20/2016	44
D	Windows	5/20/2016	68
A	Windows	5/21/2016	54
B	Windows	5/21/2016	23
C	UNIX	5/21/2016	11
D	Windows	5/21/2016	34
A	Windows	5/22/2016	78
B	Windows	5/22/2016	34
C	UNIX	5/22/2016	12
D	Windows	5/22/2016	45

When we create a chart with average of usage for server having windows OS we get the following chart

Server	OS	=Avg({$<OS={'Windows'}>} Usage)
		44.111111
A	Windows	57.333333
B	Windows	26
D	Windows	49

Now here in the above chart server A and D are having average usage above 45 . Can we get the count of the Server in having above 45 usage in displayed in a Text. The desired output is 2 but not sure how can we display this in text box

Message was edited by: Binod Kuma

Re: Need Help

PrashantSangle — Wed, 25 May 2016 06:12:07 GMT

Hi,

try like

sum(if(aggr(YourAvgExpression,os,server)>45,1)

edited:

=Sum(aggr(if(Avg({<OS={'Windows'}>} Usage)>45,1),OS,Server))

This will work

Regards

Re: Need Help

Wed, 25 May 2016 06:18:48 GMT

=if(aggr(Expression,os,server)>45,avg({<os={'Windows'}>]usage)

Re: Need Help

Anil_Babu_Samineni — Wed, 25 May 2016 06:30:07 GMT

Like this, Or tell me what you are expecting

Re: Need Help

sujeetsingh — Wed, 25 May 2016 06:33:24 GMT

Can you please give a sample or come in more words.

Re: Need Help

Kushal_Chawda — Wed, 25 May 2016 06:37:37 GMT

try below expression in text box

=Count({<Server={"=avg({<OS = {'Windows'}>}Usage)>45"}>} distinct Server)

Re: Need Help

kamal_sanguri — Wed, 25 May 2016 06:39:21 GMT

Hi,

take a look into attached file..

-Kamal

Re: Need Help

Wed, 25 May 2016 06:45:37 GMT

Hi,

try this one

=Count({<Server={"=avg({<OS = {'Windows'}>}Usage)>45"}>}Distinct Server)

-Joyson G

Re: Need Help

Anonymous — Wed, 25 May 2016 06:53:48 GMT

Hello kamal

Your expression is correct . Only >45 as underlined below should be used as per requirement

Only thing is count({<OS={'Windows'},Usage={'>45'}>}Server)

Dear Binod Kumar

If you can mark correct answer if your issue is resolved it would help other members.

Thanks & Regards

Chintan

Re: Need Help

kamal_sanguri — Wed, 25 May 2016 07:22:57 GMT

oops, I think, I didn't understand the problem at first place..

I did this in script..

Pls have a look.