topic Re: select field action using YearName field in QlikView

select field action using YearName field

sangland2 — Sun, 02 Nov 2014 21:41:46 GMT

Hi, I have a filter on a FiscalYear field which was created in the script using YearName(PostingDate). Displayed as 2014-2015. In an action on a button I cannot use Select Field function to select this field. Other date fields are OK. Setting the field to Max(FiscalYear) also does not work. Other date fields are OK eg setting PostingDate to Max(PostingDate). It seems that the initial YearName function in the script is saving the data other than a sting or date number? Any ideas appreciated. Thanks.

Re: select field action using YearName field

swuehl — Sun, 02 Nov 2014 22:10:23 GMT

Have you already tried a

=Maxstring(FiscalYear)

as search string expression?

Re: select field action using YearName field

ecolomer — Sun, 02 Nov 2014 22:10:28 GMT

Can you upload an example file to see the problem better?

Re: select field action using YearName field

danieloberbilli — Sun, 02 Nov 2014 23:25:19 GMT

Maybe something else happens in the script with the FiscalYear field. Did you check if there are any other (e.g. date#()) functions used later on or the field was accidentally loaded twice with other settings/interpretations/values?

Re: select field action using YearName field

sangland2 — Sun, 02 Nov 2014 23:27:36 GMT

Thanks MaxString(FiscalYear) does work.

Re: select field action using YearName field

sangland2 — Sun, 02 Nov 2014 23:30:30 GMT

Yes, the yearname date value was being modified by a variable:

=yearname(PostingDate,0,$(vFiscalStartMonth))

So I had to do the same in teh select action expression to locate the correct values.

Thanks for your prompt replies.

Re: select field action using YearName field

danieloberbilli — Sun, 02 Nov 2014 23:35:17 GMT

the problem might be in your select action expression - could you post this too?