topic Re: Set analysis filter in QlikView

Set analysis filter

Thu, 09 Aug 2012 16:18:18 GMT

Status	Call
S	1
S	2
S	3
N	4
N	5

Here i need to get output as maximum value with status as 'S'. so i am using set analysis... with

=only({<call={"$(=max(call))"}>}call).... i will get maximum value as 5... as out put..

Status	Call
S	-
S	-
S	-
N	-
N	5

Now i tried =only({<Call={"$(=max(Call))"},Status={"S"}>}Call)....and =only({<Status={"S"},Call={"$(=max(Call))"} >}Call)....but the my put is like below...

i didn't get any value..

Status	Call
S	-
S	-
S	-
N	-
N	-

and one more issue i am facing, tried to supress the Null values...then the out put must be

Status	Call
S	3

but it fails,,, i supressed every thing i need to do.. please telle me solution for the above suitation..

Thanks in advance...,

Ganesh.Avula.

Re: Set analysis filter

giakoum — Thu, 09 Aug 2012 16:22:15 GMT

max( {<[Status]="S">} Call)

Re: Set analysis filter

Thu, 09 Aug 2012 16:35:17 GMT

max( {<[Status]="S">} Call) ---- i am getting out put as

Status	Call
S	1
S	2
S	3
N	-
N	-

i need only S -- 3.. i tried only(max( {<[Status]="S">} Call)) but the output is all Null...

and give me the solution for filtering the null value...

Re: Set analysis filter

MayilVahanan — Thu, 09 Aug 2012 16:46:13 GMT

Try like this,

=aggr(Max({<Status={'S'}>}Call),Status)

Tick suppress null values

Re: Set analysis filter

Thu, 09 Aug 2012 16:49:32 GMT

No it doesnt work...and supress already i given but not works..

Thanks,

ganesh.

Re: Set analysis filter

MayilVahanan — Thu, 09 Aug 2012 17:05:52 GMT

See the first sheet, straight table.Hope it helps

Re: Set analysis filter

Fri, 10 Aug 2012 02:06:37 GMT

Thank U very much....