topic Re: Expression help !!! in QlikView

Expression help !!!

ganeshreddy — Wed, 27 May 2015 15:13:42 GMT

Hi All,

The following expression is not working.

if(CId_Count>1,concat(distinct ServiceType,',')&'Multiple',concat(distinct ServiceType,',')) as Service_String

can any one help.

Cheers,

Ganesh

Re: Expression help !!!

m_woolf — Wed, 27 May 2015 15:16:50 GMT

Can you say more than "not working"? Is Service_String empty? Are you getting an error? Can you attach a sample qvw?

Re: Expression help !!!

ganeshreddy — Wed, 27 May 2015 15:25:34 GMT

Hi mike,

It says Invalid expression, when i am using the following expression it is working fine, but if i try to add if condition to add string called 'Multiple' it is not working.

concat(distinct ServiceType,',') as Service_String (Working Fine)

if(CId_Count>1,concat(distinct ServiceType,',')&'Multiple',concat(distinct ServiceType,',')) as Service_String (NotWorking)

Cheers,

Ganesh

Re: Expression help !!!

m_woolf — Wed, 27 May 2015 15:30:33 GMT

Do you have a field named CId_Count? Notice that the second letter is a capital I not an L

Re: Expression help !!!

sunny_talwar — Wed, 27 May 2015 15:35:38 GMT

mike woolf‌ How did you figure that out that it is not l but I? hahahaha looks the same to me

Re: Expression help !!!

ganeshreddy — Wed, 27 May 2015 15:35:58 GMT

Thanks for the replay Mike, It is not a problem with 'CId_Count' name is correct and i got that field in table. Can you tell me, here can i add string (Multiple) like that or is there any other ways to do that ?

Cheers,

Ganesh

Re: Expression help !!!

m_woolf — Wed, 27 May 2015 15:40:09 GMT

I don't think there is a problem with: concat(distinct ServiceType,',')&'Multiple'

Try it in a textbox.

Re: Expression help !!!

Qrishna — Wed, 27 May 2015 15:43:17 GMT

Try this.

if(CId_Count>1,concat({1<ServiceType=P(ServiceType)>}distinct ' ,Multiple, ' & ServiceType) ,concat(distinct ServiceType,',')) as Service_String.

This gives you result like below screenshot.

Krishna

Re: Expression help !!!

ganeshreddy — Wed, 27 May 2015 17:26:57 GMT

Hi Krishna,

we can not use set analysis in Script. have you got any other options to archive this.

Thanks,

Ganesh

Re: Expression help !!!

Qrishna — Wed, 27 May 2015 17:36:43 GMT

Try this:

if(CId_Count>1,ServiceType & ' ,Multiple', ServiceType & ',') as Service_String.

it gives you same result.

Re: Expression help !!!

rwunderlich — Wed, 27 May 2015 18:28:06 GMT

Is CId_Count part of your GROUP BY clause? It needs to be or you will have to apply an aggregation to CId_Count.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Expression help !!!

MarcoWedel — Wed, 27 May 2015 18:55:48 GMT

please post your complete load statement.

thanks

regards

Marco