Highlight a customer whose address changed within last 7 days.

[baratiram]

hi all,

I am very new to Qlikview. can someone help me to solve this report.

I have Table1 has below columns and it has only the latest records

Customer,
Name1,
Address,
ShortName,

And Table2 has below columns which has the change in address with Date for the same customer

Customer,
FromDate

Address

My requirement is to show all the columns values  from Table1 which is latest - I did this using the straight table

And highlight the customer if there is any change in address for him in last 7 days. - need help on this

[undergrinder]

Hi Barati,

you mention QlikView, but this is a QlikSense topic, so I assume the QV as a typo.

so the table2 is the History, and just the last 7 days data needed. I would create a flag in Table 1 based on table 2.

Table1:
Load
     Customer,
     Name1,
     Address,
     ShortName
From/Resident [table];

left join(Table1)
Load
     Customer,
     Address,
     1 as flag
From/resident 
Where FromDate>=today()-7;
The left join()... part's keys will be the Customer and the Address, assume one customer may have multiple Address.
G.

[baratiram]

Thank you Gabor. But I am using Qlikview for creating this report and not Qliksense.

Does this above Load script will work for Qlikview also?

table1 always

And I want to highlight the customer whose address changed in last 7 days

[undergrinder]

I think this script works i QlikView as well.

Be aware customize some part to fulfill your requirements like tablenames, From/resident part.