8 Replies Latest reply: Apr 19, 2018 4:54 PM by Joey Lake RSS

    Show Total and Yesterday only in KPI chart dynamically

    Joey Lake

      Hello all, first time poster (fairly new to Qlik, but very quick learner).


      I've got a set of data that goes back till beginning of 2017, and I update it daily through previous day.  I'd like to use a KPI chart to show the TOTAL Revenue for the selected time, as well as show Yesterday's revenue dynamically (ideally this wouldn't change if you selected various dates through the standard date/month chooser. 


      Data Columns in question are "Day" and "Revenue (USD)"


      Any help would be appreciated - Thank you