Comparing data between two Expressions from different tables

[#1]

Hi ,

Can we compare data between two expression from different tables.

Attached the QVW.

There are 4 tables each table with different expressions. How do i compare between tables.

Lets say if data(Enq_ContactName) is available in last table  it should not be shown in any other tables

Please help me with this.

Thanks in advance,

Regards,

Keerthi KS

[#2]

Issue with the case i have selected. Its already in last table and it should not be shown in the other table.

As per the condition given its showing correctly. But that should not be shown.

[Anonymous]

Okay, just share the Offc_status for every table like:

For table 1 which status you want, similarly for table 2.

Only Offc_Status, no other flag.

Will arrange the data in to each and every table as per your Offc_Status only, then you can edit those with your further filters.

[#4]

Please find the attached updated QVW.

Table 1 Offer Status =Expired and Offer Status<>'Draft' along with the current condition which is the expression

Table 2 Offer Status =Expired and Offer Status<>'Draft' along with the current condition which is the expression

Table 3 Offer Status =Expired and Offer Status<>'Draft' along with the current condition which is the expression

Table 4 Data is proper Off_status = Draft and Off_status<>Expired.

[Anonymous]

1st three condition are same:

and why you are using this:(Offer Status =Expired and Offer Status<>'Draft' ) : it states that consider those whose status is Expired and also consider those  whose status is other than Draft which is again considering Expired and Other status as well.

Try only:  Offer Status =Expired and your other conditions.

Hope this will help!!

[#6]

I used the below condition for table 3

if(len(trim(Off_Start_Date))=0,

If(SitevisitDate<>Null() and len(trim(TermSheetSignedDateTime))=0,

If(CurrentStatus<>'Expired',

If(CurrentStatus<>'Dropped',

If(CurrentStatus<>'Closed',

If(CurrentStatus<>'Converted',

if(LeadCallQ_Status<>'Disqualify',

Enq_ContactName,

)))))),If(Off_Status='Expired'  and SitevisitDate<>Null(),Enq_ContactName

))

Its showing the names in table4 also.

Ex : Balakrishna Adiga and Mr Pavani

[#7]

Any other Solution ???

[Anonymous]

Give me some time, working on it. Let me see, if anything I can do,..

[Anonymous]

For table 3:

=if(len(trim(Off_Start_Date))=0,

If(SitevisitDate<>Null() and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status<>'Draft',

if(LeadCallQ_Status<>'Disqualify',

Enq_ContactName,

))))

For table 4:

=if(Off_Start_Date<>Null()

and len(trim(TermSheetSignedDateTime))=0,

if(Off_Status='Draft',

if(LeadCallQ_Status<>'Disqualify',

,Enq_ContactName)

))

Would it remain same for every table??

[Anonymous]

Also SitevisitDate is only for 1st 3 tables? not for 4th?

[#11]

Not for 4th. Still the data is coming for Balakrishna Adiga