Hello everyone, I'm learning to use qlik sense: I created an application on qlik sense that calculates certain kpis at each data reload (which happens once a day). I'd like to know if there is a way to be able to compare the kpi calculated today with those calculated yesterday. Not having a Date field, I created it in the script like this:
rename table Table_1 to Table_1_tmp; NoConcatenate Table_1: load*, date(timestamp(now())) as Timestamp resident Table_1_tmp; drop table Table_1_tmp;
however it is not clear to me now how I could compare the kpis calculated today with those calculated yesterday. I tried something like this, but looking back on it I don't think it's correct because reviewing the code I'm not keeping track of yesterday's results: