topic Re: Aggr inside set analysis in QlikView

Aggr inside set analysis

inescastelhano — Mon, 26 Sep 2016 14:38:26 GMT

Hi all,

Could somebody tell me if there is any problem with this expression? The aggr part is working alone but not when integrated within the set analysis expression.

Only({<FIELD1={'something'}, FIELD2={$(=Aggr(Max(FIELD2), FIELD3))}>}FIELD4)

Thanks in advance.

Cheers,

Inês

Re: Aggr inside set analysis

sunny_talwar — Mon, 26 Sep 2016 14:41:41 GMT

You are comparing FIELD2 to an aggregate with a FIELD4? Is this right? Have you checked this in a straight table to see if you see the right information?

Dimension

FIELD2

Expression

=Aggr(Max(FIELD3), FIELD4)

Re: Aggr inside set analysis

inescastelhano — Mon, 26 Sep 2016 14:44:46 GMT

You are right, my mistake! Should be:

Only({<FIELD1={'something'}, FIELD2={$(=Aggr(Max(FIELD2), FIELD3))}>}FIELD4)

The problem is the same, I only made the mistake when writing the expression here.

Thanks

Re: Aggr inside set analysis

sunny_talwar — Mon, 26 Sep 2016 14:47:06 GMT

This worked?

Only({<FIELD1={'something'}, FIELD2={$(=Aggr(Max(FIELD2), FIELD3))}>}FIELD4)

Re: Aggr inside set analysis

inescastelhano — Mon, 26 Sep 2016 14:54:51 GMT

No, it doesn't work.

Re: Aggr inside set analysis

sunny_talwar — Mon, 26 Sep 2016 14:57:04 GMT

Hahahaha that's what i figured. I think it would be better if you share a sample (dummy data) and the expected output to help you. The expression doesn't look right, but offering a suggestion would be difficult without knowing what you are trying to do.

Best,

Sunny

Re: Aggr inside set analysis

Anonymous — Mon, 26 Sep 2016 14:57:05 GMT

Hi Ines,

If you want the Max of Field2 based on Field3, then use :

Only({<FIELD1={'something'}, FIELD2={$(=Max(Aggr(Max(FIELD2), FIELD3)))}>}FIELD4)

Else, if you wan Max value of Field2 for each Field3, then use:

Only({<FIELD1={'something'}, FIELD2={$(=Concat(Aggr(Max(FIELD2)),FIELD3),','))}>}FIELD4)

Regards!!!

Re: Aggr inside set analysis

inescastelhano — Mon, 26 Sep 2016 15:29:20 GMT

Doesn't work either.

Re: Aggr inside set analysis

Anonymous — Tue, 27 Sep 2016 06:16:04 GMT

Hi Ines, could you attach one example of your data?

Thanks!