LOAD * FROM [Data.qvd];
LOAD * Resident Table1
order by ID, Day desc;
// desc makes yesterday above today
Drop Table Table1;
if(ID=peek(ID) and Day='Today' and peek(Day)='Yesterday','Yes','No') as Trigger
Drop Table Table2;
FROM [https://community.qlik.com/thread/242957] (html, codepage is 1252, embedded labels, table is @1);
if(ID=Peek('ID') and Day='Today' and Peek('Day')='Yesterday', 'Yes', 'No') as Flag
ORDER BY ID, Day DESC;
DROP Table Source;
You can easily achieve this by using Mapping Load, try below script
WHERE Day = 'Yesterday';
If(Day = 'Today' AND ApplyMap('YesterdayMapping', ID, 'N/A') = 'Yesterday', 'Yes') AS Trigger
Hope this helps you.
Hey guys thanks for your help. But I realized this is not helping my script.
I have attached excel file, hope this will explain which I want same in qlik sense.
Dat2.xlsx 50.7 K
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?