Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

ignore selection with set expressions

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

1 Solution

Accepted Solutions
MVP
MVP

Re: ignore selection with set expressions

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

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

4 Replies
trdandamudi
Honored Contributor

Re: ignore selection with set expressions

May be as below:


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

Not applicable

Re: ignore selection with set expressions

Thanks but it doesn't work eihter

MVP
MVP

Re: ignore selection with set expressions

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

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

Not applicable

Re: ignore selection with set expressions

That's the solution,

Thanks a lot Swuehl!!

Community Browser