topic Re: Previous Month Assigning to a Variable in QlikView

Previous Month sales value Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 07:38:23 GMT

Hello all,

I am having Master Calender, now I have to assign last 6 month to six variable on the basis of Calender selection.

Example: FYear, FMonth in Calender

Say user selects April 2014

then my variable should have like this:

V1= April 2014

V2= March 2014

V3= Feb 2014

V4= Jan 2014

V5= Dec 2013

V6= Nov 2013

Pls suggest.

Regards,

Balraj

Re: Previous Month Assigning to a Variable

anbu1984 — Thu, 09 Oct 2014 08:11:51 GMT

Check this qvw

Re: Previous Month Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 08:25:51 GMT

Anbu,

Will it capture those month which comes into next or previous year??

Re: Previous Month Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 08:33:41 GMT

Say,

I am having 2013 year as well,

if I selects Dec 2013, will it give Jan 2014???

Re: Previous Month Assigning to a Variable

anbu1984 — Thu, 09 Oct 2014 08:42:39 GMT

Yes it will give Jan 2014

Re: Previous Month Assigning to a Variable

krishna20 — Thu, 09 Oct 2014 08:48:41 GMT

Dear Balraj,

Please find the below attachment what you are looking for. i just modified anbu cheliyan APP.

Regards

Krishna

Re: Previous Month Assigning to a Variable

Thu, 09 Oct 2014 09:21:30 GMT

Dear Balraj,

Use AddMonth function for this functionality.

This function is very useful for these kind of functionality.

For Exp:-v1:-month

v2=addmonth(month,-1)

v3=addmonth(month,-2)

v4=addmonth(month,-3)

v5=addmonth(month,-4)

v6=addmonth(month,-5)

AddMonth automatically transfer to last year.

for e.g if year is Jan-2014 then automatically it does Dec-2013.

Thanks & Regards

Prince Anand

Re: Previous Month sales value Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 09:24:42 GMT

Krishna,

I have edit it and added sales of the month as well.

Could you help me to get the sales of these month as well in similar fashion.

Say,

If I select Jan 2014 then It should give me the sales of last 3 month

Jan 2014 Sales:100

Dec 2013 Sales:128

Nov 2013 Sales:500

like this......

Re: Previous Month sales value Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 09:26:03 GMT

I have uploaded your sample file by editing it.

Re: Previous Month sales value Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 09:29:53 GMT

Prince,

It will pick garbage value in this case..........

Re: Previous Month sales value Assigning to a Variable

Thu, 09 Oct 2014 09:32:46 GMT

Dear Balraj,

It will not pick any garbage value.

Thanks & Regards

Prince Anand

Re: Previous Month sales value Assigning to a Variable

its_anandrjs — Thu, 09 Oct 2014 09:38:40 GMT

Use AddMonths features for this.

Re: Previous Month sales value Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 09:55:47 GMT

Prince,

It is picking, pls chk

Re: Previous Month sales value Assigning to a Variable

Thu, 09 Oct 2014 10:20:42 GMT

Dear Balraj,

You have different field for Year and Month or one concatenated field year-month?

Thanks & Regards

Prince Anand

Re: Previous Month sales value Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 10:41:19 GMT

In my case, Both field are different, Prince.

Pls suggest.

Re: Re: Previous Month sales value Assigning to a Variable

Thu, 09 Oct 2014 11:16:13 GMT

Dear Balraj,

Please find the attached qvw for solution.

Thanks & Regards

Prince Anand

Re: Re: Previous Month sales value Assigning to a Variable

Anonymous — Thu, 09 Oct 2014 11:48:41 GMT

Prince,

I have already done this but now I am looking to get sales value of these month as calender changes.

I have already attached the sample data....