Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how can i find different values between two string variable?

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

1 Solution

Accepted Solutions
jeffmartins
Contributor II

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

Hi masoudsol2000,

In this case swuehl post solve your problem.

See the attached file.

Regards

4 Replies
MVP
MVP

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

Maybe like this?

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

Regards,

Stefan

jeffmartins
Contributor II

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

Hi masoudsol2000

You can use the purgechar function to do this.

See the attached file.

Regards

Not applicable

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

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
Contributor II

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

Hi masoudsol2000,

In this case swuehl post solve your problem.

See the attached file.

Regards

Community Browser