topic Re: concat does not work in my variable in QlikView

concat does not work in my variable

msmichael — Sat, 16 Nov 2024 03:32:30 GMT

Hi experts,

I have two fields - myyear and mymonth. There's a list for myyear for users to choose a year.

I created two variables, one is vSelectedYear, definition is =GetFieldSelections([myyear]), this is used to record the year that is currently selected by user.

The other variable is called "vYearPlugMonths", the purpose of the variable is to get the list of months that are available in the selected year, plus the unselected years..

For example, I have data list below,

myyear	mymonth
2016	1
2016	2
2016	5
2017	10
2017	11
2017	12
2018	1
2018	2

so when user selects 2016, the variable should be: 2017,2018,1,2,5 (because 1, 2, 5 are available months in 2016)

when user selects 2017, the variable should be: 2016,2018,10,11,12 (because 10,11,12 are available months in 2017)

and so on.

I used this definition: =Concat({<myyear-={'$(vSelectedYear'}>} [myyear]) & Concat({1 <myyear={'$(vSelectedYear)'}>} chr(39) & [mymonth] & chr(39), ',')

but it did not work.

Could anyone please shed some light? The qvw file is attached..

Thanks,

Michael

Re: concat does not work in my variable

dplr-rn — Fri, 17 May 2019 21:17:33 GMT

change your variable to below. red is pieces i added

=Concat(DISTINCT{1<myyear-={'$(vSelectedYear)'}>} [myyear]) & Concat({1 <myyear={'$(vSelectedYear)'}>} chr(39) & [mymonth] & chr(39), ',')

Also the variable name in the text box was not right

Re: concat does not work in my variable

msmichael — Fri, 17 May 2019 21:48:55 GMT

Hi Dilipranjith,

sorry for the typos... I tried your definition and corrected the variable name, now I receive error:

Error: Garbage after expression: "10"

new qvw file attached..

Thanks,

Micahel

Re: concat does not work in my variable

dplr-rn — Fri, 17 May 2019 23:16:38 GMT

remove the = at start of the variable definition.

Mark as answered and close the thread please