topic Re: Matching values from one column to another in QlikView

Matching values from one column to another

rsdhavle — Mon, 01 Sep 2014 10:01:37 GMT

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?

Re: Matching values from one column to another

tresB — Mon, 01 Sep 2014 10:04:42 GMT

In the script use Exists(), like:

Load

From <> where exists(B,A):

Re: Matching values from one column to another

rsdhavle — Mon, 01 Sep 2014 10:06:02 GMT

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

Re: Matching values from one column to another

tresB — Mon, 01 Sep 2014 10:08:33 GMT

Listbox? Chart? Could you explain the scenario better?

Re: Matching values from one column to another

simenkg — Mon, 01 Sep 2014 10:09:31 GMT

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}>}

Re: Matching values from one column to another

rsdhavle — Mon, 01 Sep 2014 10:10:24 GMT

yes i am doing it in straight table chart

Re: Matching values from one column to another

ashfaq_haseeb — Mon, 01 Sep 2014 10:35:49 GMT

Hi,

May be like this.

Regards

ASHFAQ

Re: Matching values from one column to another

MarcoWedel — Mon, 01 Sep 2014 10:56:31 GMT

another one in front end only:

hope this helps

regards

Marco

Re: Matching values from one column to another

rsdhavle — Mon, 01 Sep 2014 12:59:48 GMT

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