topic Chart Dimension Last 3 months in QlikView

Chart Dimension Last 3 months

Wed, 12 Aug 2009 03:40:21 GMT

Hi All...this may be too simple but I'm totally stuck....

I have 3 data fields - Month, Year, Dollar Value....

I'm trying to create a bar chart...that lists out the Dollar value for the last 3 months (from the maximum possible Month and Year combination)....

In the chart dimension I used the following code to filter out the months but it doesn't seem to work. Any quick ideas please?


If(Addmonths(MakeDate(max([Year]),max([Month])),-3) >=MakeDate([Year],[Month]),Month(MakeDate([Year],[Month])))

Wed, 12 Aug 2009 05:57:10 GMT

Hi,

Create a calculated field
```
makedate(year,month)
```
Sort your dimesions according numeric value from sort tab.
Go to presentation tab and check the max visibible number option and then enter 3 .

You can also look at the sample.

Best Regars.

Wed, 12 Aug 2009 23:32:19 GMT

Thanks very much, Önder....This is exactly what I was looking for...Thank you....