Discussion Board for collaboration related to QlikView App Development.
i want to sort the months (without year specification) in the order of the month_id (which refers to a corresponding "month_year" field)
i have attached the test app
I have Chart 1 and Chart 2. Chart 1 is sorted according to %month_id. I want as final result the Chart 2, which is a difference of values of current month minus a previous set of months. I want the value difference expressed as a month without specifying the year, but this shall be sorted (as showed in Chart 2).
In Chart 2, instead of displaying Sep.2014, it shall be displayed only " Sep ".
Calculation: "Value of Sep.2014 (84) - Value of Sep.2013 (83) " is showed as the "difference" which shall be displayed in Chart 2, but sorted as Sep.2014. The final value is " -1 ". The next value is the difference between Aug.2014 and Aug.2013 displayed as "Aug" and so on.
Thanks for any help on this
Here the test Table:
load * inline [
thanks, no, it did not work
i adjusted the test application, to reflect better the real app
Chart 2, under the given conditions, cannot be sorted with expressions or load order
see the attached app !
Hi Felipe, I don't understand what isn't working, I tested both options proposed by gysbert and mine.
If I select May.14 with the three options it shows months from Dez to Mai. Wich result you expect?
i expect the Dimension "month" sorted from, say apr,march,feb,jan,dec,nov,oct,,etc. in that sequence.
Ex. if i select in the app
prev_month = 6
month_year_text = Mar.2014
i get this, when i have to get Mrz,Feb,Jan,Dez,etc.
If you load the data a little differently, this becomes quite simple:
LOAD Date(month_id, 'MMM.YYYY') As DateMY,
|Month(month_id) As Month,|
Now DateMY is a dual field which you can sort numerically. The other two date fields are redundant as all the information is in DateMY and %month_id.