topic Re: Start chart from April in QlikView

Start chart from April

sifatnabil — Thu, 10 Apr 2014 09:55:58 GMT

Hi all,

How can I have a chart with Month as Dimension start from April instead of January? Since this is the UK tax year, it starts from April. Thanks.

Re: Start chart from April

alexandros17 — Thu, 10 Apr 2014 09:58:44 GMT

if you have month in dimension (e.g.: yyyymm -> 201401 for jabuary 2014) you may write as modified dimension:

if(myMonth >= 201403, muMonth, null()) and exclude null values

Re: Start chart from April

senpradip007 — Thu, 10 Apr 2014 09:58:51 GMT

try like this:

SET MonthNames='Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec;Jan;Feb;Mar';

in Main tab of ypur script.

Re: Start chart from April

yduval75 — Thu, 10 Apr 2014 09:59:08 GMT

in your expression :

Sum ({<Month={>=4}>} Data)

Re: Start chart from April

rustyfishbones — Thu, 10 Apr 2014 10:02:53 GMT

Hi,

You could try changing the SET in the Main Tab like

Re: Start chart from April

Thu, 10 Apr 2014 10:07:48 GMT

In your model generate Monthnum for each month

Ex:

Map1:

Load * Inline [

Month, MonthNum

Apr, 1

May, 2

Jun, 3

Jul, 4

Mar, 12

];

YourTable:

Load *,

Applymap('Map1',Month) as MonthNum

From Yoursource;

After getting this column from your script do this,

Chart Dimenssion(Month) -> Sort expression ->=Only({1}MonthNum)

Re: Re: Start chart from April

Thu, 10 Apr 2014 10:13:46 GMT

Update:

In UI:

Use this in Chart Dimension(Month) sort expression

=Wildmatch(Month,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar')

Re: Start chart from April

sifatnabil — Thu, 10 Apr 2014 10:56:20 GMT

Thanks, this works half way - The chart starts from April 2013, but after December 2013, it shows the sum for Jan 2013 instead of Jan 2014, thus showing a misleading figure. Is there a way to have the chart go from April 2013, May 2013.......Dec 2013, Jan 2014, Feb 2014, Mar 2014?

My graph looks like this after using your method (and full accumulation turned on):

I'm basically trying to get the chart to look like this, but with it starting from April:

Re: Re: Start chart from April

Thu, 10 Apr 2014 11:07:18 GMT

In the expression use filter for the year like

=Sum({<Year={$(=Max(FinancialYear))}>}Sales) or

=Sum({<Year={'$(=Max(FinancialYear))'}>}Sales) or

vMaxFinancialYear = Max(FinancialYear) //Create variable

=Sum({<Year={$(vMaxFinancialYear)}>}Sales)

Hope it will work..

Re: Start chart from April

senpradip007 — Thu, 10 Apr 2014 11:21:18 GMT

Create a Calendar for your application as Apr is the starting month and make the year - 1 for Jan, Feb and Mar.

Eg.

Normal Calendar Transform_Calendar

Jan 2014 Jan 2013

Feb 2014 Feb 2013

Mar 2014 Mar 2013

Apr 2014 Apr 2014

Dec 2014 Dec 2014

Jan 2015 Jan 2014

Feb 2015 Feb 2014

Mar 2015 Mar 2014

Re: Start chart from April

rajat2392 — Thu, 10 Apr 2014 11:25:43 GMT

See the demo app in attachment, I think it will solve your problem.

Re: Start chart from April

sifatnabil — Fri, 11 Apr 2014 06:20:31 GMT

Thanks a lot, this worked perfectly!

Re: Start chart from April

rajat2392 — Fri, 11 Apr 2014 08:41:46 GMT

pleasure...

good to know your problem solved...