Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
nandhaadjame200
New Contributor II

Need to flag a table record based on another table latest record

 

Hi There

Need to flag a table record based on another table latest record.

Contact:

Email Address, Subscribed

1@test.com, Yes

2@test.com, No

 

Unsubscribed:

Email Address, Date

2@test.com, 11/3/2018

 

When a contact subscribe or unsubscribe the record will comes in "Unsubscribed" table and based on the latest status i've to flag the "Contact" table.

 

Please help to achieve this in load script.

 

Thanks

Nandhakumar

2 Replies

Re: Need to flag a table record based on another table latest record

How Unsubscribed table will come? Can you specify the result what you want to look?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
nandhaadjame200
New Contributor II

Re: Need to flag a table record based on another table latest record

Example.png

Hi There 

I hope you will understand the scenario with the provided example.

Please let me know for more details

Thanks

Nandhakumar