topic Start with specific month in QlikView

Start with specific month

Anonymous — Thu, 23 Feb 2012 20:13:31 GMT

Hi guys,

Help me create an expression which show data from specific month( for example from November 2011) in a chart.

When I load my data, I use it to calculate Month of Year.

MonthName(Monthstart(submitDateTime)) as MYear,

Thanks,

Start with specific month

Thu, 23 Feb 2012 22:18:28 GMT

Hi vovan4ik,

You can try loading the 'submitDateTime' as island table. Then code a variable

vMYear = MonthName(Monthstart(submitDateTime)) by going to Setting --> Variable overview --> Add

Once you have done that, create your chart with an appropriate dimension.

Add an expression with set analysis as below:

sum( {1<Month ={'$(vMYear)'}>} sales)

where Month is the calendar field with same format as vMYear and sales is the detail field that you wnat the chart to be based off of.

Thanks

Start with specific month

v_iyyappan — Fri, 24 Feb 2012 05:28:58 GMT

Hi,

cau u attach a sample file.because its only easy to solve ur requirments

Iyyappan

Re: Start with specific month

Anonymous — Mon, 27 Feb 2012 16:58:26 GMT

Hi guys,

Please find attched the file. I need to show data started from Sep 2011.

Thanks,

Re: Start with specific month

Anonymous — Mon, 27 Feb 2012 21:33:58 GMT

Could you help me to create variable, which shows or have months started from Sep 2011 and ...?

In chart or in Load.

Thank you in advanced,

Start with specific month

v_iyyappan — Tue, 28 Feb 2012 05:53:40 GMT

Hi,

Use the Where Condition in Load Script'

Table2:

Load

Date,

Month(Date) AS Month,

Value AS Amount

Resident Table1

Where (Month(Date) * 1) >= 9;

Regards,

Iyyappan

Start with specific month

SunilChauhan — Tue, 28 Feb 2012 06:13:57 GMT

convert your Myear in

Month-Year format ex: Jan-2012

and the use below code

sum({<myear={">=$(=addmonths(max(mYear),-12))<=$(=addmonths(max(mYear),0))"}>} Sales)

hope this helps

Re: Start with specific month

Anonymous — Tue, 28 Feb 2012 16:28:37 GMT

I found out issue:

in expression

IF(Num(MYear)>" insert number of month", sum(Var)