topic max year in QlikView

max year

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

i have cleard the dash board ,now i wanna dispaly max year details even after i clear ,but without triger

Re: max year

Anil_Babu_Samineni — Mon, 18 Dec 2017 09:14:28 GMT

May be assign for all reports using {<Year = {$(=Max(Year))} >}

Re: max year

Chanty4u — Mon, 18 Dec 2017 09:14:37 GMT

you can try with option set clear state .

select whatever you want in the dashboard and set clear state and save close open again you will see default selection

Re: max year

surendraj — Mon, 18 Dec 2017 09:15:20 GMT

Select maximum year-->In Clear-->Set to clear state-->this will shows your max year even you clear the app.

Re: max year

Chanty4u — Mon, 18 Dec 2017 09:15:47 GMT

here

Re: max year

YoussefBelloum — Mon, 18 Dec 2017 09:18:10 GMT

you can do it with a Button associated with actions.

Create a Clear Button:

1st action: clear all selections

2nd action: select the Max Year

Re: max year

devarasu07 — Mon, 18 Dec 2017 09:20:00 GMT

Hi,

Have your tried with always one selected value option? if not you can try to select any value in the Year list box, after that to list box properties and select General > "Always One Selected Value" enable check box.

i would suggest best way go with trigger and always one selected value option (trigger used to auto fetch the max year value and always one selected value prevent from clear selection)

Thanks,

Deva

Re: max year

avinashelite — Mon, 18 Dec 2017 09:23:34 GMT

create a variable to store the max date and use the same in all the charts where you need to show the max date

Re: max year

vignesh_s — Mon, 18 Dec 2017 09:31:45 GMT

thanks,but i used =only(year) every where in my dashboard ,is thr any short cutr in single step to change all =only(year) to =max(year)

Re: max year

vignesh_s — Mon, 18 Dec 2017 09:34:09 GMT

i wanna same action to perform without trigger,any how i got solution thanks

Re: max year

Anil_Babu_Samineni — Mon, 18 Dec 2017 09:35:40 GMT

No way, I feel it as always maintain Variables for future maintenance. So, that is very easy to change for all sheets at a time effect for single change. This time, you cannot do that maintain.

Re: max year

devarasu07 — Mon, 18 Dec 2017 09:42:24 GMT

Hi,

without trigger you can go with Avinash suggestion. try to do below steps,

1) create variable

vMaxYear

=max( {1}Year)

2) create any chart object then try to use that variable in your chart expression,

for example,

sum( {$<Year={$(vMaxYear)}>}Sales)

Re: max year

vignesh_s — Mon, 18 Dec 2017 09:42:44 GMT

oh ok thanks

Re: max year

its_anandrjs — Mon, 18 Dec 2017 09:56:09 GMT

I believe if you use =Max(Year) and even if you clear the selections you get max value of the year.