topic Highlight a customer whose address changed within last 7 days. in App Development

Highlight a customer whose address changed within last 7 days.

baratiram — Wed, 08 Aug 2018 17:12:31 GMT

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

Re: Highlight a customer whose address changed within last 7 days.

undergrinder — Thu, 09 Aug 2018 09:21:15 GMT

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.

Re: Highlight a customer whose address changed within last 7 days.

baratiram — Fri, 10 Aug 2018 14:40:18 GMT

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

Re: Highlight a customer whose address changed within last 7 days.

undergrinder — Mon, 13 Aug 2018 13:41:09 GMT

I think this script works i QlikView as well.

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