Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Previous date data

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.

5 Replies
YoussefBelloum
Esteemed Contributor

Re: Previous date data

Hi,

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

ashishpalkar
Contributor II

Re: Previous date data

Yes , thats correct.

YoussefBelloum
Esteemed Contributor

Re: Previous date data

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
Contributor II

Re: Previous date data

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
Esteemed Contributor

Re: Previous date data

So i Think you can close this thread