topic Re: how can i find different values between two string variable? in QlikView

how can i find different values between two string variable?

Fri, 21 Dec 2012 14:01:21 GMT

i have a problem to find different values between two variables

for example one of the my variable contain that strings : 'A','B','C' and another one have this values : 'A',B','C','D' , so the different between these variable is D.

how can i find this value in the expressions? with which functions?

thanks a lot

Re: how can i find different values between two string variable?

swuehl — Fri, 21 Dec 2012 14:06:01 GMT

Maybe like this?

http://community.qlik.com/message/162166

Regards,

Stefan

Re: how can i find different values between two string variable?

jeffmartins — Fri, 21 Dec 2012 14:14:08 GMT

Hi masoudsol2000

You can use the purgechar function to do this.

See the attached file.

Regards

Re: how can i find different values between two string variable?

Fri, 21 Dec 2012 15:55:43 GMT

thanks jeff for ur answer

but in the my real problem, i have word values

for example Va='book','pen','cat','dog' and Vb='book','pen','umbrella'

so i want Va-Vb='cat','dog'

what can i to do?

thanks

Re: how can i find different values between two string variable?

jeffmartins — Fri, 21 Dec 2012 20:04:12 GMT

Hi masoudsol2000,

In this case swuehl post solve your problem.

See the attached file.

Regards