topic Re: Fiscal year YTD chart - months sorting in QlikView

Fiscal year YTD chart - months sorting

Tue, 04 Mar 2014 08:23:38 GMT

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

Re: Fiscal year YTD chart - months sorting

Tue, 04 Mar 2014 08:31:16 GMT

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

month(date) as your dimension instead of Usek

Re: Fiscal year YTD chart - months sorting

Tue, 04 Mar 2014 08:38:04 GMT

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

Re: Fiscal year YTD chart - months sorting

Tue, 04 Mar 2014 08:41:11 GMT

share your qvw

Re: Fiscal year YTD chart - months sorting

Tue, 04 Mar 2014 08:43:00 GMT

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

check this link helpful to you.

reagrds

Mahesh

Re: Fiscal year YTD chart - months sorting

Thu, 06 Mar 2014 07:47:15 GMT

Hi,

the right solution is this

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

Thank you for help.