Set Analysis - dynamic chart over the last 12 months

[#1]

Hello,

I need some help in Set Analysis. I searched in the forum for a solution of my problem but nothing works for me.

Problem description:

Fields: 1) Ticketnumber (ex. 5, 14, 1265, 3459......)

2) YearMonth (ex. 2006-Jan, 2006-Nov, 2007-Jul, 2009-Mrz ....) ==> format is 'YYYY-MMM'

Endresult:

I select only 1 value in the listbox "YearMonth" for example "2009-Jan" I would like to have a bar chart which shows me 12 bars, from "2008-Feb" to "2009-Jan", for each YearMonth one bar. As dimension in the barchart I have "YearMonth" and as Formula I would like to have a count(Ticketnumber).

The selection should be flexible I always select only 1 value in the field "YearMonth":

Selection: "2008-Sep" ==> so the bar chart includes the date range 2007-Okt to 2008 Sep

I hope the information is enough that somebody could help me with a set analysis formula! Thanks.

[#2]

Thanks for the application, I think there is a tricky problem, when I opened it, yes it is true that it shows 12 bars, that ok, but when I select for example Dez-2007 than it should show the hole year, but there are 2 null values in the month March and July and there the bar shows completely different values, take a look at the screenshots, I have change nothing.

Than I have tested it with my basic setting in the script, and overrided with mine.

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='#.##0,00 €;-#.##0,00 €';
SET TimeFormat='hh:mm';
SET DateFormat='DD.MM.YYYY';
SET TimestampFormat='YYYY-MM-DD hh:mm[.fff]';
SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';
SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

And there was again my old problem with the missing 2 bars, March and July with the 0 values where missing.

Very strange, I think I test the application with a other version of QlikView and than I report here again.

[sparur]

Herbert,

try to make a reload. Once again I have updated(reload) and save, it feels good.

[#4]

I reinstalled QlikView once again, and now it shows me the correct values, also the 0 values, very strange, I cannot explain it why there where first wrong values. Thanks for the .qvw

Now I will try it with the data of my real application and if it also works when I include some modifications in the set analysis set. Maybe there is an error also in the basic skript somewhere. Thanks for the moment!

[sparur]

That's good!

I was glad to help you.

[#6]

Hi Herbert,

Recently I had problem with a complex expression on the QV 8.5 wich wasn't the newest 8.5. After upgrading it to the most recent version, the expression started working correctly...

Cheers

Karol