topic GetFieldSelections in QlikView

GetFieldSelections

Wed, 04 Jul 2012 11:47:45 GMT

Hi, people

i have this func:GetFieldSelections(filed) and i have an Multiple select and i want to get the higest select.

like: 2010,2011,2012 and get only 2012. (i do it on variables)

Someone know how to do it?

Re: GetFieldSelections

Wed, 04 Jul 2012 11:50:28 GMT

Hello.

Try with Max(field)

Create a variable with:

=Max(field)

Re: GetFieldSelections

Wed, 04 Jul 2012 13:16:17 GMT

thankes for answering but it's still not working

this is what i do

=GetFieldSelections($(vMaxYear))

but isn't give any value in the text box (for cheaking)

Re: GetFieldSelections

MayilVahanan — Wed, 04 Jul 2012 13:24:36 GMT

Hi,

Create a variable like vMaxYear = max(Year)

and use the variable in text box like =vMaxYear

and select the years in list box.. You will get the maximum year ,,

Hope it helps

Re: GetFieldSelections

Wed, 04 Jul 2012 13:37:36 GMT

i try to be more clear

the user select years:

and i want to take the max year from is select.

if i use GetFieldSelections(years) i get this in text box: 2009,2010,2011.

Now i want to get the max result in this case :2011

what can i do?

Re: GetFieldSelections

MayilVahanan — Wed, 04 Jul 2012 13:41:49 GMT

Hi,

Can you say the result of max(years) in your case. That help to fix the issue.

Re: GetFieldSelections

Wed, 04 Jul 2012 13:42:42 GMT

2012

Re: GetFieldSelections

MayilVahanan — Wed, 04 Jul 2012 13:49:12 GMT

Hi,

Did you check after select the years, and if so, please give in the text object itself ,and check once = max(years) without variable .. I hope it works...check the filed name once..

Re: GetFieldSelections

Wed, 04 Jul 2012 14:22:43 GMT

it is working in the textbox, but when i put it in the func: =GetFieldSelections($(vMaxYear))

i get null.

what can i do?

Re: GetFieldSelections

Wed, 04 Jul 2012 15:01:11 GMT

I have a 3 table of big,good(up) and bad(Down) brunchs and a chart to show the progres in time line.

now, when someone select for e.g. 2009,2010,2011 he get in the chart the up & down every month/Q/year

and in table he should get the change from 2009 till 2011 the problem is when he clik more than one year

he get null if it only to year i have soulition =GetFieldSelections(KeyYear)-1 and it work

but i want more dinamic for the user.

Re: GetFieldSelections

swuehl — Wed, 04 Jul 2012 15:11:22 GMT

I don't really get your point.

The suggested

=max(KeyYear)

e.g. in a variable defintion will return the max possible KeyYear (2012 if nothing is selected, or the maximum KeyYear within the selected list of KeyYears).

Just drop the GetFieldSelections() function.

If you only want to get a result when the user has selected at least one KeyYear, define your variable like

=if(GetSelectedCount(KeyYear), max(KeyYear) )