Fiscal year YTD chart - months sorting

[#1]

Hello,

I'm new to QV so my knowledges regarding to the system are poor. So I would like to ask you for help with following issue:

My company has fiscal year 1 Apr - 31 March and I'm trying to design graph showing comparison of budgeted and actual variable and fixed costs YTD.

QV skript sets:

- Month (Měsíc) as 01 = Jan, 02 = Feb,...12 = Dec and Month_Financ (Měsíc_Financ) as 01 = Apr, 02 = May...12 = March;

- Year (Rok) e.g. 2013 for period 1 Jan 2013 - 31 Dec 2013 and Year_Financ (Rok_Financ) 2013 for period 1 Apr 2013 - 31 March 2014

Some tips from discussions helped me to create these expressions:

BUDGET ({<Rok_Financ={$(=max(Rok_Financ))},Date={'<=$(vMaxDate)'},Měsíc=,Hkategorie={'Režijní náklady'}>}Castka_Plan)

Obviously this is not correct since the expression shows all values until the end of fiscal year.

ACTUAL ({<Rok_Financ={$(=max(Rok_Financ))},Měsíc={'<=$(=Max(Měsíc))'},Hkategorie={'Režijní náklady'}>}If(JeProjInv_MD=$(cOstat),Castka_MDD,0))*(-0.001)

This looks a little bit better but the problem is that the chart shows months based on numerical sorting, means that April is shown correctly on the right side of the chart but when I select Oct 2013 in list box I just want to see data for 04 - 10 / 2013.

Could anybody help me please?

Thank you, Lucie

[#2]

use month() function to create dimension if you have dates

month(date) as your dimension instead of Usek

[#3]

The dimension is correct - Mesic (month) - you can see it near no. 02 - sorry for the Usek - there was one chart hidden below and this dimension has nothing to do with the chart

[#4]

share your qvw

[#5]

Hi

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year

check this link helpful to you.

reagrds

Mahesh

[#6 · Accepted solution]

Hi,

the right solution is this

Sum({<Year_Financ={$(=max(Year_Financ))},Date={'<=$(=Max(Date))'},Month=>}Sales)

Thank you for help.

L.