Trigger or Flag

[DipeshVadgama]

Dear Friends,

I am stuck in my data, appreciate if any one can help me.

I have a data with ID, Day.

I what to know which id was present today & also yesterday then Trigger or flag it in other field as Yes.

and to others as No (ID was present today but not yesterday or ID was present yesterday but not today)

Eg.

ID	Day	Trigger
ID12345	Yesterday
ID12346
ID12347	Yesterday
ID12348
ID12349	Yesterday
ID12350	Yesterday
ID12351	Yesterday
ID12352
ID12353	Yesterday
ID12354	Yesterday
ID12355
ID12345	Today	Yes	Trigger this as Id was present today and yesterday
ID12346	Today
ID12347
ID12348	Today
ID12349	Today	Yes	Trigger this as Id was present today and yesterday
ID12350	Today	Yes	Trigger this as Id was present today and yesterday
ID12351
ID12352	Today
ID12353
ID12354	Today	Yes	Trigger this as Id was present today and yesterday
ID12355	Today

[MK9885]

PFA.

I'm not sure if this is what you're looking for.

I added Master Calendar for my own benefit... You can delete that script.

And also added 12/13/2016 in your XL to check for todays date.

I'm sorry I didn't realize you require it for Sense. But it will be same (the script and expressions)

Front end will change cus the UI for Pivot table is different in Qlik Sense. Maybe use normal table to represent the data?

Thanks.