topic Re: Show last 6 months data on chart in QlikView

Show last 6 months data on chart

AlexJohnsyn — Sat, 16 Nov 2024 18:49:50 GMT

Hello,

I'm trying to restrict a chart to only show the last 3 months data. I have a simple sum of '$amount' as the expression. This is shown by date (using a master calendar) showing only MM-YYYY 'monthyear_date'.

I would like to restrict the dimension to show only last 3 months. Any help appreciated.

Re: Show last 6 months data on chart

lironbaram — Mon, 06 Apr 2020 08:55:46 GMT

you could use something like this

sum({<Date= {">=$(=addmonths(monthstart(max(Date)),-2))"}>Amount)

Re: Show last 6 months data on chart

AlexJohnsyn — Mon, 06 Apr 2020 09:31:59 GMT

Thank you, I hope I've used this correctly? Because I keep receiving a "allocated memory exceeded" error..

sum({<monthyear_date= {">=$(=addmonths(monthstart(max(monthyear_date)),-2))"}>Amount)

Re: Show last 6 months data on chart

lironbaram — Mon, 06 Apr 2020 11:26:27 GMT

it seems ok ,

does the month field and the amount field are in the same table

if not , how are they connected

Re: Show last 6 months data on chart

sergio0592 — Mon, 06 Apr 2020 13:05:43 GMT

Hi, you can avoid AddMonths with :

sum({<Date= {">=$(=monthstart(max(Date),-2))"}>Amount)