How can I exclude a value from a string?

Anonymous — Mon, 01 Jun 2015 19:10:42 GMT

Hi,

I'm using a Concat function for a certain task:

Concat(DISTINCT Media, ', '). This function returns a set of currently selected media. E.g. TV, Press, Radio.

My task is to exclude a certain value on a certain condition.

I'll give an example:

- Let's say there's a condition which is regulated by Var_A. If Var_A=1, then I want TV to be excluded from the output of the concat function.

- Imagine that all three media have been selected by the user via a listbox: TV, Press, Radio. I can not clear a user-defined selection.

- But if Var_A=1, then I need to exclude TV from the output of the Concat function, though it is selected via a listbox at the moment.

In other words I need something like:

if Var_A=1 then fulfill Concat(DISTINCT Media, ', ') but exclude 'TV'

The underlined text is not QV-syntax.

Can I convert it to QV-syntax?

Thank you in advance,

Larisa

Re: How can I exclude a value from a string?

jonathandienst — Tue, 02 Jun 2015 06:34:03 GMT

Like this?

=Concat(DISTINCT If(Var_A <> 1 Or Media <> 'TV', Media), ', ')

jonathandienst — Tue, 02 Jun 2015 06:35:19 GMT

Answer gone to moderation

Anonymous — Tue, 02 Jun 2015 07:54:18 GMT

Thank you!