topic Re: Comparing data between two Expressions from different tables in QlikView

Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 04:18:51 GMT

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

Re: Comparing data between two Expressions from different tables

settu_periasamy — Thu, 05 Nov 2015 05:15:53 GMT

Hi,

I think, we can't compare the Other chart expressions. May be you can create a variable which you have used expression for other chart and compare with your current chart.

Or You can try with Aggregation of fields and do the comparison

Note:

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

I checked your chart, i think it looks fine already.

check the excel attached which i combined all the expressions in a single chart..

Re: Comparing data between two Expressions from different tables

jonathandienst — Thu, 05 Nov 2015 05:16:24 GMT

Please reduce the size of your uploaded qvw. See here: Preparing examples for Upload - Reduction and Data Scrambling

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 05:30:49 GMT

Hi Periasamy,

When we select Mr. Balakrishna Adiga From Enq_Contact Name.

It displays in two tables. Last table and the table next to it.

Because it has two Off_Status Expired and Draft.

Since its already displayed in Last Table it should not be shown in the Next table.

Can you please help me with the solution.

Regards,

Keerthi KS

Re: Comparing data between two Expressions from different tables

Anonymous — Thu, 05 Nov 2015 05:30:55 GMT

What exactly you want?

Your all table contains Enq_ContactName as a dimension..

Contact Name appearing in table 4 should not come in another tables, is it?

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 05:32:08 GMT

Reduced the data.

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 05:34:10 GMT

yes Balraj. Names should be in any one table.

Its like a stages. Customer will move from first to last table. The customer who was in first table will move to each table.

Re: Comparing data between two Expressions from different tables

Anonymous — Thu, 05 Nov 2015 05:43:59 GMT

But ae per you Offc_Status Data, one contact name is having multiple status.

MR K B Singh, he is into 3rd and 4th table beacoz he is having two status i.e Draft and Expired,

and if you split this status into two tables, it would come in both the table.

Re: Comparing data between two Expressions from different tables

jonathandienst — Thu, 05 Nov 2015 05:45:42 GMT

You may have overdone the reduction slightly . I would have kept 2 or 3 names with different statuses rather than just the one.

But if i understand you correctly - there is no way for one table to know directly what is or is not displayed in another table. But if the expressions in the two tables are mutually exclusive, then the name will only appear in one table.

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 05:47:50 GMT

yes there will be multiple status for Enq_Contact name. Expired and Draft.

If its draft it will be shown in 4th table and also for same Enq_contact name it will be expired. Those records should not be shown in the other tables.

tried with the expression i am not getting properly

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 05:50:02 GMT

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.

Re: Comparing data between two Expressions from different tables

Anonymous — Thu, 05 Nov 2015 06:03:49 GMT

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.

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 06:14:52 GMT

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.

Re: Comparing data between two Expressions from different tables

Anonymous — Thu, 05 Nov 2015 06:25:24 GMT

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

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 06:35:54 GMT

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

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 07:25:35 GMT

Any other Solution ???

Re: Comparing data between two Expressions from different tables

Anonymous — Thu, 05 Nov 2015 07:35:26 GMT

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

Re: Comparing data between two Expressions from different tables

Anonymous — Thu, 05 Nov 2015 08:06:08 GMT

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

Re: Comparing data between two Expressions from different tables

Anonymous — Thu, 05 Nov 2015 08:07:15 GMT

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

Re: Comparing data between two Expressions from different tables

Thu, 05 Nov 2015 09:22:14 GMT

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