Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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!
That's good!
I was glad to help you.
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