topic Re: If in Aggr funcation in QlikView

If in Aggr funcation

Wed, 28 Jan 2015 11:52:30 GMT

Hi all

Im facing the following problem. really appricate your help.

lets say I have the following table:

I want for each activity ID that its type is only "A" Ill display the biggest value.

the request table i would like to show is:

how can I use the aggr funcaiton?

thanks!

Anonymous — Wed, 28 Jan 2015 12:11:48 GMT

Hello,

PFA

HTH

agomes1971 — Wed, 28 Jan 2015 12:12:47 GMT

Hi,

please see attached.

HTH

André Gomes

Clever_Anjos — Wed, 28 Jan 2015 12:39:45 GMT

Use Set Analysis

Wed, 28 Jan 2015 13:11:36 GMT

Thank you all so much you really helped me!!

maybe you could help me to achieve also the following.

lets say I have additional coulmn to the original table:

I want to display only the error activities of the biggest Type id so the table will be like the following:

is that possible?

thanks!