topic Ignore Selection in straight table with Aggr and Maxstring in QlikView

Ignore Selection in straight table with Aggr and Maxstring

BootCam — Sat, 16 Nov 2024 04:56:48 GMT

Hi ,

I would like to ignore selections when [Field 1], [Field 2], [Field 3], [Field 4], [Field 5], [Field 6] is selected. With below mentioned calculation, it's not working.

=Aggr(
MaxString({<[Field 1]=,[Field 2]=,[Field 3]=,[Field 4]=,[Field 5]=
,[Field 6]=>}[Data Availability Quarter Year]),[Field 5])

Whats wrong in the calculation? Any help is appreciated.

Thanks,

Re: Ignore Selection in straight table with Aggr and Maxstring

sunny_talwar — Mon, 17 Dec 2018 18:13:43 GMT

Try this

=Only({<[Field 1], [Field 2], [Field 3], [Field 4], [Field 5]
, [Field 6]>} Aggr(
MaxString({<[Field 1], [Field 2], [Field 3], [Field 4], [Field 5]
, [Field 6]>} [Data Availability Quarter Year]),[Field 5]))

Re: Ignore Selection in straight table with Aggr and Maxstring

BootCam — Mon, 17 Dec 2018 18:25:04 GMT

Awesome Sunny! Thanks a lot.

Best,