topic Re: ignore selection with set expressions in QlikView

ignore selection with set expressions

Thu, 12 May 2016 15:11:50 GMT

Hi all,

I'm trying to ignore selections in the field [Booking Month] and at the same time forcing to get the higher value for the field [Booking Week] with this formula and it's not working:

sum({<[Booking Month],[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

If I use the next formula I ignore the selection made in [Booking Month] field:

sum({<[Booking Month]} >}Pax)

and if I use the next formula I will get the result for the higher value for [Booking Week] field:

sum({<[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

Do you know how can I combine both? maybe is because both dimensions are related?

thanks,

David

Re: ignore selection with set expressions

trdandamudi — Thu, 12 May 2016 15:13:54 GMT

May be as below:

sum({<[Booking Month]=,[Booking Week]={"$(=date(max([Booking Week])))"} >}Pax)

Re: ignore selection with set expressions

Thu, 12 May 2016 15:25:43 GMT

Thanks but it doesn't work eihter

Re: ignore selection with set expressions

swuehl — Thu, 12 May 2016 15:39:34 GMT

Are you looking for clearing user selections also in the max() aggregation?

sum({<[Booking Month],[Booking Week]={"$(=date(max({<[Booking Month]>} [Booking Week])))"} >}Pax)

Re: ignore selection with set expressions

Tue, 17 May 2016 09:48:35 GMT

That's the solution,

Thanks a lot Swuehl!!