Matching values from one column to another

[rsdhavle]

I have two columns A and B. I want to show only those values from Column A which are available in Column B. How can i do that. Which function can be used?

[tresB]

In the script use Exists(), like:

Load

          A,

          B

From <> where exists(B,A):

[rsdhavle]

Can we control it at Object level? I dont want to restrict values at main script level.

[tresB]

Listbox? Chart? Could you explain the scenario better?

[simenkg]

how about doing something like this

Table1:

Load A, B from File.qvd (qvd)

left join(Table1)

load B as A, 1 as ValidFlag from File.qvd (qvd);

then you can select ValidFlag = 1 in the front end or use set analysis with {<ValidFlag = {1}>}

[rsdhavle]

yes i am doing it in straight table chart

[ashfaq_haseeb]

Hi,

May be like this.

Regards

ASHFAQ

[MarcoWedel]

another one in front end only:

hope this helps

regards

Marco

[rsdhavle]

You have written the condition in expression part..Lets say i want to control it at Dimension level then writing   =If(Match(A, $(=Concat({1} B, ','))), A)  will work?

As i need to display filtered A values in chart