Solved: Re: syntax problem? - Qlik Community

Report Inappropriate Content · ‎2012-07-23

Hi All,

Anybody knows where the problem is with my calcul?

=Concat( KeepChar( GetFieldSelections(YEAR),('0123456789')),',')

Thanks,

Report Inappropriate Content · ‎2012-07-23

Ok I add ',' in '0123456789' and it worked , thanks

CELAMBARASAN · ‎2012-07-23

There is no syntax problem with this make sure that you have field in the name of YEAR?

Report Inappropriate Content · ‎2012-07-23

I have it but does not show any thing in text box

I mean it does not work

and it does not put the ',' between the years !

CELAMBARASAN · ‎2012-07-23

Did you checked by selecting the year?because you used GetFieldSelections works only if the fieldvalues gets selected

Report Inappropriate Content · ‎2012-07-23

yes I did and still no ',' .....

MayilVahanan · ‎2012-07-23

Hi,

Can i know, what you're requirement..GetFieldSelections(Year) itself give comma separated. like 2007,2008

Keepchar() remove comma in your value->20072008 as single value..Then why using give concat(expression,',')

so no response in it..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-07-23

Because If I select 2011 and less, it shows >2011 which I don't want to see like it...

CELAMBARASAN · ‎2012-07-23

What you are trying to do?

Report Inappropriate Content · ‎2012-07-23

Ok I add ',' in '0123456789' and it worked , thanks

CELAMBARASAN · ‎2012-07-23

Do you have value in the list box like <2011,>2011like that?