I have a small problem when using the master calendar in QlikView. In the database, I have one date field, 'update_date_cps_full'. I have used this field in the master calendar. In Set analysis, I want the latest date balance and previous date balance. Since Sunday is not a working day, I are removed it from my calendar.
My expression (mentioned below) works fine for current date balance and previous date balance when there is no selection of date, but whenever I select a date in history, the current balance shows correctly but the previous day balance disappears.