topic Re: Latest 7 days data in chart in QlikView

Latest 7 days data in chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table with 3 fields, products brought, price and start_date.

I have a graph, where am using "Products brought" in Dimension and "price" in Expression. I have one month of data in the chart.

i have a field called start_date,

where in the chart i need to display products brought and price of latest week (last 7 days only)

Help me to find this.

devarasu07 — Wed, 21 Sep 2016 04:52:33 GMT

Hi Kishore,

By using dimension limit value at chart property you can able to achieve it.

Hope this will help you.

Thanks

Deva

tresB — Wed, 21 Sep 2016 05:29:20 GMT

Try like:

Sum({<Date={'>$(=Date(Max(Date)-7))<=$(=Date(Max(Date)))'}>}Sales)

PFA