Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

syntax problem?

Hi All,

Anybody knows where the problem is with my calcul?

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

Thanks,

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

12 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

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

Not applicable
Author

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
Partner - Champion
Partner - Champion

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

Not applicable
Author

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

MayilVahanan

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.
Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

What you are trying to do?

Not applicable
Author

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

CELAMBARASAN
Partner - Champion
Partner - Champion

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