topic functions inside set analysis in QlikView

functions inside set analysis

Fri, 07 Aug 2009 00:23:04 GMT

Hi,

Can I use functions inside set analysis, like so:

sum({$<ReservationDate={getfieldSelections(OtherReservationDate)}>} Sales)

Thanks!

functions inside set analysis

johnw — Sat, 08 Aug 2009 04:09:03 GMT

Yes, but the syntax is very ugly:

sum({<ReservationDate={$(=chr(39) & replace(getfieldselections(OtherReservationDate),', ',chr(39) & ',' & chr(39)) & chr(39))}>} Sales)

The getfieldselections() function returns a list of comma separated values. I don't think set analysis likes that format, though. I believe it wants them in quotes, which is where the replace() and all the chr(39) values come in.

A much easier approach to at least try would be to use an IF. I suspect it would be slower, but it's hard to know without testing.

sum(if(ReservationDate=OtherReservationDate,Sales))

I haven't tested either. Might have bugs.

functions inside set analysis

elif-tutuk — Wed, 24 Feb 2010 22:59:06 GMT

You can also compare 2 fields in set analysis. Thanks!

sum({$<ReservationDate=OtherReservationDate}>} Sales)