topic Re:month to month in QlikView

month to month

Thu, 23 Sep 2010 12:09:18 GMT

Hi all

i want to show the values for the months of one month before the current month,current month and one month after the current month,

that is if i select jun then i should show the values for may,jun,july months in bar charts...........

can anyone help me....

how to do this

month to month

tresB — Thu, 23 Sep 2010 12:33:01 GMT

Hi,

Probably you are using the MONTH as dimension. If it is so, you may use CALCULATED DIMENSION. make a variable 'PreMaxMonth' to hold the previous month. then use the calculated expression conceptually as : if(MONTH>='PreMaxMonth' and MONTH<PreMaxMonth+3, MONTH)

Along with this one more thing you will have to do, and that is - use SET ANALYSIS {1} to avoid the present selection. Because it would the already done against the dimension.

Hope i could give you some idea. if not clear please upload your application sample.

Regards,

tresesco

month to month

Thu, 23 Sep 2010 12:50:14 GMT

hi..

you r right month as the dimension,

can u give me the details clearly...

what is the premaxmonth..

month to month

Thu, 23 Sep 2010 13:01:39 GMT

Do you can use a macro for select values in a field.

The idea is that when select June in a field of selection or an input box automatically selected in the field that is used in the table values may, jun and jul

If do you dont know as do it, tell me an prepared a example.

Regards

Re:month to month

Thu, 23 Sep 2010 13:13:53 GMT

I dont know how to do this...

also i m not familiar in macros...

can u give me the ideas to develop....

i want to show the sum(sales) in the bar chart regarding the months,

i.e,if i select the month jun,i want to show the values for may,jun,july regarding the company

thanks in advance

month to month

Thu, 23 Sep 2010 17:40:15 GMT

Hi,

try using set analysis:

sum({$<Month={'$(#=month(max(Date)))','$(#=month(max(Date))+1)','$(#=month(max(Date))-1)'}>} sales)

regards!

Re:month to month

Thu, 23 Sep 2010 18:07:17 GMT

Hi,

Please see the attached sample application which is in line with your requirement.

Please revert back for any further query in this regard.

Re:month to month

Fri, 24 Sep 2010 07:08:54 GMT

thanks for giving information...

its working fine...

if i select two year values r not added...I want to add the values

how to do this.

suppose if i select 2009 and 2010,then month=jun

i want to add 2009 jun and 2010 jun as well as 2009 may,2010 may and 2009 july and 2010 july

thanks in advance

Re:month to month

Fri, 24 Sep 2010 07:58:03 GMT

Hi,

Please see the attached modified application. Here we have created a variale called v3Months (which contains current/previous/next month values). Then this variable we are using in our set expression inside the graph. Please refer to Month 2 Month - || (Consolidated across years) graph.

Re:month to month

tresB — Fri, 24 Sep 2010 08:00:07 GMT

Hi ,

Though this might not be the best solution, still it would give what you want.

Regards,

tresesco

Re:month to month

Sat, 25 Sep 2010 07:33:27 GMT

thanks for ur previous reply.its work fine...

if i select jan it should show the previous year dec and the current year Feb and the jan...

also if i select the dec,it should show the nov and next year jan values

thanks in advance...