topic Re: syntax problem? in QlikView

syntax problem?

Mon, 23 Jul 2012 20:30:37 GMT

Hi All,

Anybody knows where the problem is with my calcul?

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

Thanks,

Re: syntax problem?

CELAMBARASAN — Mon, 23 Jul 2012 20:33:21 GMT

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

Re: syntax problem?

Mon, 23 Jul 2012 20:35:34 GMT

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 !

Re: syntax problem?

CELAMBARASAN — Mon, 23 Jul 2012 20:38:28 GMT

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

Re: syntax problem?

Mon, 23 Jul 2012 20:39:43 GMT

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

Re: syntax problem?

MayilVahanan — Mon, 23 Jul 2012 20:40:31 GMT

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..

Re: syntax problem?

Mon, 23 Jul 2012 20:42:08 GMT

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

Re: syntax problem?

CELAMBARASAN — Mon, 23 Jul 2012 20:42:41 GMT

What you are trying to do?

Re: syntax problem?

Mon, 23 Jul 2012 20:43:05 GMT

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

Re: syntax problem?

CELAMBARASAN — Mon, 23 Jul 2012 20:44:38 GMT

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

Re: syntax problem?

Mon, 23 Jul 2012 20:47:21 GMT

yes

Re: syntax problem?

CELAMBARASAN — Mon, 23 Jul 2012 20:51:41 GMT

Yes then you have include ,(comma) in keep char or

use PurgeChar(Expression,'><')

Re: syntax problem?

MayilVahanan — Mon, 23 Jul 2012 20:54:02 GMT

Hi,

Ya,Use PurgeChar(Expression,'<>') instead of keepchar function as Celambarasan said.