topic Re: Set expression in QlikView

Set expression

Architect — Thu, 25 Feb 2021 04:16:13 GMT

Can anyone please explain the meaning of this condition?

[Base Year] = max({1} [Base Year])

If I select 2021 as Base Year, what will be the output?

Re: Set expression

jwjackso — Wed, 24 Feb 2021 20:00:45 GMT

The {1} ignores filters and represents the complete data set. No matter which year you select, you should get the maximum year.

Re: Set expression

Architect — Thu, 25 Feb 2021 04:11:16 GMT

HI @jwjackso

Thanks for the explanation.

Though I am looking for something more detailed.

[Base Year] = max({1} [Base Year])

if we select 2018,2019,2020 and 2021 one after another will the condition be satisfied every time?

I can see with the change of the [Base Year] selection the output value is changing too.

Re: Set expression

MayilVahanan — Thu, 25 Feb 2021 06:22:58 GMT

Hi @Architect

Max({1}BaseYear) gives always the maximum Year. For ex: In your case, its 2021.

If you create the text box, and use this [Base Year] = max({1} [Base Year]) expression.

Output will be -1 when you select 2021, else it will give zero at all the remaining case.

Hope it helps

Re: Set expression

marcus_sommer — Thu, 25 Feb 2021 06:28:15 GMT

Like mentioned the {1} ignored any selections within the expression of max({1} [Base Year]). Just put it within a text-box to see if it changed by any selections. If your overall expression which contained this as an expression-part did change it means that the other parts are further directly associated to selections.

- Marcus

Re: Set expression

jwjackso — Thu, 25 Feb 2021 14:48:12 GMT

In the first image, "=[Base Year]=Max({1}[Base Year])" is returning a boolean (True (-1) or False(0)). In the filter pane, 2018 is selected. "Max([Base Year]) is returning the maximum of the years available, 2018. "Max({1}[Base Year]) looks at all the years and returns 2021.

In the second image, 2020 is selected in the filter pane. "Max([Base Year]) is returning the maximum of the years available, 2020. "Max({1}[Base Year]) looks at all the years and returns 2021.