how can i find different values between two string variable?

[#1]

hi

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

[swuehl]

Maybe like this?

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

Regards,

Stefan

[jeffmartins]

Hi masoudsol2000

You can use the purgechar function to do this.

See the attached file.

Regards

[#4]

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

[jeffmartins · Accepted solution]

Hi masoudsol2000,

In this case swuehl post solve your problem.

See the attached file.

Regards