Previous date data

[ashishpalkar]

Hi There

I am creating QS App, I want to show selected day data and previous date data.

e.g If user selects any date from list box

For the below scenario when we select portfolio 1491 and BusinessDate as 10/20, it should display 10/20 data + previous date data for the portfolio( i.e., 10/13). Please find screenshot of the report. Request your help in achieving this.

[YoussefBelloum]

Hi,

on every line you have the selected DATE + PRICE and DATE-1 + PRICE-1 ?

[ashishpalkar]

Yes , thats correct.

[YoussefBelloum]

here you have all the information you need on the same line.

so just create a table, put your dimensions and measures and just select a portfolio and a Businessdate, you will have the actual and the previous data.

is it clear or I'm missing something ?

[ashishpalkar]

Yes , you are correct. When user select any date. It should show data for that selected date and immediate previous date in the database.

[YoussefBelloum]

So i Think you can close this thread