Master Calender and difference between same columns/rows of atwo diff tables

ankit_tikoo — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need your help in two issues:

1. I need to link date fields of two separate tables to a master calender. The two tables will be created from same data with diff columns haedings

2. Once this is done. I will create chart tables using both tables separately as below:

Chart table 1: This actually contains the situation at a date L1

Salesperson Name A+ Client B+ Client C+ Client

Job Smith Yes Yes No

Ashton Jones No Yes Yes

Lara Janes Yes Yes Yes

Chart table 1: This actually contains the situation at a date L2, which is more recent than L1

Salesperson Name A+ Client B+ Client C+ Client

Job Smith Yes Yes No

Ashton Jones Yes Yes Yes

Lara Janes Yes Yes Yes

I want the below table:

Salesperson Name A+ Client B+ Client C+ Client

Job Smith NA NA NA

Ashton Jones +ve NA NA

Lara Janes NA NA NA

Total 1 0 0

Wherever there is a change in status at L2 as compared to older date L1,

1. If it changes from Yes to Yes, show NA

2. If it changes from No to No, Show NA

3. If it changes from No to Yes, show +ve

4. If it changes from Yes to No, Show -ve

So, I want to populate 3rd table on basis of first two tables. I also want to add positive changes for all salespersons to rate their performance.

Thanks

topic Master Calender and difference between same columns/rows of atwo diff tables in QlikView