topic Re: Set Analysis in QlikView

Set Analysis

kamal_sanguri — Thu, 26 May 2016 14:26:33 GMT

Hi,

I have one inline table:

**********************************************************

Data:

Load *

Inline

[

Server, Usage

A,10

B,25

A,15

B,12

A,40

C,25

C,30

];

**********************************************************

Now, I want to see which server has the max usage. I want to do that in expression.

using max(aggr(sum(Usage),Server)), I can figure out the max usage of the server but how I can get the name of server.

Thanks,

Kamal

Re: Set Analysis

Kushal_Chawda — Thu, 26 May 2016 14:30:09 GMT

try this

= max({<Server ={"=sum(Usage)>0"}>}Usage)

=FirstSortedValue(DISTINCT Server, -aggr(sum(Usage),Server))

Re: Set Analysis

trdandamudi — Thu, 26 May 2016 14:31:09 GMT

May be as below:

firstsortedvalue ( Server, -Usage )

Re: Set Analysis

kamal_sanguri — Thu, 26 May 2016 14:31:57 GMT

and i dont want to use variables to calculate the usage of individual servers.. .

Re: Set Analysis

kamal_sanguri — Thu, 26 May 2016 14:34:35 GMT

It didn't work..sorry

Re: Set Analysis

Kushal_Chawda — Thu, 26 May 2016 14:39:20 GMT

what is the output you need for below data

Data:

Load *

Inline

[

Server, Usage

A,10

B,25

A,15

B,12

A,40

C,25

C,30

C,15

];

Re: Set Analysis

Kushal_Chawda — Thu, 26 May 2016 14:41:14 GMT

This will not work .. as it will not aggregate the data for server and will give you wrong result

Re: Set Analysis

kamal_sanguri — Thu, 26 May 2016 14:43:48 GMT

the server which has the most usage. so technically after group by the server with max usage.

Re: Set Analysis

trdandamudi — Thu, 26 May 2016 14:51:15 GMT

How about the below:

=firstsortedvalue (Server, -Aggr(Sum(Usage),Server ))

Re: Set Analysis

kamal_sanguri — Thu, 26 May 2016 14:55:08 GMT

Correct this time..

Re: Set Analysis

Kushal_Chawda — Thu, 26 May 2016 15:02:16 GMT

was my answer something different?

Re: Set Analysis

Kushal_Chawda — Thu, 26 May 2016 15:06:31 GMT

kamal_sanguri one suggestion , before you mark the correct answer just check if somebody has already replied or not and mark the correct answer who replied first

Re: Set Analysis

sinanozdemir — Thu, 26 May 2016 15:31:49 GMT

Just a thought. If you want to show only the server that has the highest usage, you can also use Rank() function in text box as below:

Thanks

Re: Set Analysis

sunny_talwar — Thu, 26 May 2016 17:24:05 GMT

Gussa nai bhai

Re: Set Analysis

kamal_sanguri — Thu, 26 May 2016 17:47:37 GMT

Fair point.. I just saw your first reply.. and when I saw the solution from someone else, I didn't realize that you have already responded.. I will make correction..

I just reached home and saw email notification that I have messed up things heavily..

-Kamal

Re: Set Analysis

kamal_sanguri — Thu, 26 May 2016 17:48:41 GMT

Sunny Bhai, Kushal ko gussa karne do.. it was my fault..

Re: Set Analysis

kamal_sanguri — Thu, 26 May 2016 17:51:21 GMT

sorry, unmarking it as correct.. Since Kushal responded first.. he is the one who should get the credit.. Marking your reply as helpful though.. hope you will understand..

Re: Set Analysis

trdandamudi — Thu, 26 May 2016 18:11:19 GMT

I have no issues... We all help each other....

Re: Set Analysis

Kushal_Chawda — Thu, 26 May 2016 18:26:32 GMT

kamal_sanguri I hope I was not too much rude. if so I apologize for that. May be I had not structured my sentence well.

Re: Set Analysis

Kushal_Chawda — Thu, 26 May 2016 18:29:41 GMT

sunny bhai gussa nahi yaar..bas sentence thik tarah se likh nahi paya.. thoda rude aur attitude types lag raha he.. sorry for that..