topic Re: Select in Field - Variable in search string in QlikView

Select in Field - Variable in search string

Mon, 15 Apr 2013 14:59:19 GMT

HI all,

i have to select some values in a field while a variable changes its value, but the values that i have to select depend on the value of that variable.

so, if the variable (year) takes a value i have to select in field (month_name) all the months of the selected year and the last 3 of the $(year)-1.

i tried to set the search string like this :

='Jan '&$(year)&'|'&... ...&'Dec '&$(year) // all months of the selected year

&'| Oct '&($(year)-1)&'|Nov '&($(year)-1)&'|Dec '&($(year)-1) //last three months of the previous year

but does not work, nothing is selected...

any ideas??

Re: Select in Field - Variable in search string

Anonymous — Mon, 15 Apr 2013 15:37:03 GMT

Looks like you're using toggle select, and the field format is 'Jan 2013'

The only missing part is the () around your expression. It would be:

='(Jan ' ... &')'

Regards,

Michael

Re: Select in Field - Variable in search string

Tue, 16 Apr 2013 07:35:18 GMT

Thank you all for the answers!!

I solved the problem by setting the search string as follows:

='(Jan?'&$(V_year_selected)&'|' &

'Feb?'&$(V_year_selected)&'|' &

'Mar?'&$(V_year_selected)&'|' &

'Apr?'&$(V_year_selected)&'|' &

'May?'&$(V_year_selected)&'|' &

'Jun?'&$(V_year_selected)&'|' &

'Jul?'&$(V_year_selected)&'|' &

'Aug?'&$(V_year_selected)&'|' &

'Sep?'&$(V_year_selected)&'|' &

'Oct?'&$(V_year_selected)&'|' &

'Nov?'&$(V_year_selected)&'|' &

'Dec?'&$(V_year_selected)&'|' &

'Oct?'&($(V_year_selected)-1)&'|' &

'Nov?'&($(V_year_selected)-1)&'|' &

'Dec?'&($(V_year_selected)-1)&')'

i have used a toggle select on the month field