topic Re: Override Set Analysis in App Development

Override Set Analysis

alopez — Wed, 09 Aug 2023 21:52:14 GMT

Is there a way to override set analysis? If I have a table that only looks at 2023 data but now the consumer wants to see 2022 data. Is there a way to override and include my selection?

Here is the current set analysis:

=SUM({<SALES_STATUS={'Sale'},YEAR={'2023}>} SALES_PRICE)

Re: Override Set Analysis

Tanish — Thu, 10 Aug 2023 06:10:57 GMT

Hi Alopez,

Rather than using Hard Code value in the Set Analysis like

YEAR={'2023} , You can use dynamic value here like

YEAR = {"$(=Year(Max(Date)))"}

You can keep a Filter of Year at the top. By default the table will show Current Year data but, If the user select any other year then it will show that specific year data.

I hope this will help..........🙂

Re: Override Set Analysis

alopez — Fri, 11 Aug 2023 20:10:09 GMT

Interesting, what happens if the max year is not the current year by chance?

Re: Override Set Analysis

BrunPierre — Fri, 11 Aug 2023 20:47:43 GMT

Hi, such a situation could occur when the date field contains future dates. That expression takes the maximum date value from the "Date" field and extracts the year component. You can create a flag field that indicates whether a date is in the future or not, and factor in or exclude future dates in your calculations.

Re: Override Set Analysis

alopez — Fri, 11 Aug 2023 20:55:49 GMT

How would I use a flag for set analysis? I would be back at my original problem where I can't use the filters to update data.

Re: Override Set Analysis

Tanish — Sun, 13 Aug 2023 09:21:21 GMT

Then you can use Today() instead of the Max(Date) but the limitation is your date filters will not work.

Re: Override Set Analysis

BrunPierre — Sun, 13 Aug 2023 19:00:49 GMT

To filter data for the current year while excluding future years, use these modifiers

{$<Year={"$(=Year(Today()))"}, DateField = {"<=$(=Today())"}>}

Re: Override Set Analysis

barnabyd — Sun, 13 Aug 2023 22:04:40 GMT

G'day @alopez,

You don't override Set Analysis. It's the other way around. The user makes selections on the data using the filters on the page but Set Analysis can override the user selections.

What are your actual requirements? People have tried to answer your questions but I think that maybe your questions are not heading in the right direction!

Cheers, Barnaby.

Re: Override Set Analysis

alopez — Tue, 22 Aug 2023 20:02:29 GMT

The max feature is helpful for when you are working with dates.

Also using an operator for intersection was helpful as I found in another article. Set operators | Qlik Cloud Help

*=: This operator is used to define the corresponding field values based
on the intersection between what the user has selected and the values we
specify. That is, the resulting record set will be the values that "intersect" or
are present in both the user's selection and the values we explicitly define in
our element list.