topic Condition on QVD joins in QlikView

Condition on QVD joins

Mon, 17 Aug 2015 19:48:48 GMT

Hi,

I have a scenario where I don't want to display rows for specific data values of a fields in QVD's.

Ex: A.qvd is having fields x,y,z;

B.qvd is having fields x,s,t;

How to avoid values y='USA' and s='SAMSUNG' after applying inner join on two QVD's, but want all the other values to display which falls in fields 'y' & 's'.

Thanks.

Re: Condition on QVD joins

Anonymous — Mon, 17 Aug 2015 20:41:48 GMT

load *

from A.qvd

where y <> 'USA';

inner join

load *

from B.qvd

where s <> 'Samsung';

Re: Condition on QVD joins

Tue, 18 Aug 2015 00:42:00 GMT

You can try below:

Data:

LOAD X,Y,X From A.qvd Where not Match(Y,'USA') ;

Inner Join (Data)

LOAD X,S,T From B.qvd Where not Match(S,'Samsung');

Re: Condition on QVD joins

sunny_talwar — Tue, 18 Aug 2015 01:35:44 GMT

How to avoid values y='USA' and s='SAMSUNG' after applying inner join on two QVD's, but want all the other values to display which falls in fields 'y' & 's'.

May be this:

Table:

LOAD x,y,z From A.qvd

Inner Join (Table)

LOAD x,s,t From B.qvd ;

NewTable:

NoConcatenate

LOAD *

Resident Table

Where not Match(y,'USA') and not Match(s,'Samsung');

DROP Table Table;

Re: Condition on QVD joins

qlikviewwizard — Tue, 18 Aug 2015 01:41:31 GMT

Hi Please try below.

Thank you.

Table_Data:

LOAD x,y,z From A.qvd Where not Match(y,'USA') ;

Inner Join (Data)

LOAD x,s,t From B.qvd Where not Match(s,'Samsung');