topic Re: How to get select max of year when already year selected in QlikView

How to get select max of year when already year selected

Gopi_E — Sat, 16 Nov 2024 01:32:43 GMT

Hi All,

I have field with year like

Year_New

2018

2019

2020

I need to select whenever i clicked on button i want max year select,so i added action in button Actions select Field and value is =Max(Year_New),

problem is, initially when i click on button max year selected, if i select 2018 in Year_New field then if i click on button then max year function is not performed.

Please give any solution on this,

Thanks in advance

@sunny_talwar please can you look into this

Re: How to get select max of year when already year selected

Gopi_E — Fri, 10 Jan 2020 10:09:43 GMT

I got the solution

Max({1}Year_new)

Thank you

Re: How to get select max of year when already year selected

Kushal_Chawda — Fri, 10 Jan 2020 10:11:57 GMT

It's because you have used Max(Year) function. If you don't select anything it will return max year, if you select any year then it will consider that year as a max year, hence you need to exclude the selection of year field in trigger. Use max({1}Year)

Re: How to get select max of year when already year selected

Gopi_E — Sat, 11 Jan 2020 06:42:22 GMT

Thanks for the input kush,

yes, you are right,

I got the idea and it works perfectly.