topic Re: Count Month in QlikView

Count Month

NavinReddy — Wed, 12 Mar 2014 07:23:25 GMT

Hi All,

I want to count all previous three year months

01-03-2011 from to till date how many months please help me

Thanks in Advance

Niranjan

Re: Count Month

vikasmahajan — Wed, 12 Mar 2014 07:25:55 GMT

Please Find attached QVW will help you lots.

Vikas

Re: Count Month

er_mohit — Wed, 12 Mar 2014 07:31:50 GMT

Try this

=count({<Date={'>=$(=Monthstart(Max(Date),-2))<=$(=Date(Max(Date)))'},Month=>}ID)

Re: Count Month

MK_QSL — Wed, 12 Mar 2014 07:31:58 GMT

Please check enclosed file..

Re: Count Month

alexandros17 — Wed, 12 Mar 2014 07:32:02 GMT

Create 6 variables:

yearLess2start = Makedate(year(today())-2, month(today()), 1);

yearLess2end = Makedate(year(today())-2, month(today()), day(today());

yearLess1start = Makedate(year(today())-1, month(today()), 1);

yearLess1end = Makedate(year(today())-2, month(today()), day(today());

yearCurrentstart = Makedate(year(today()), month(today()), 1);

yearCurrentend = Makedate(year(today()), month(today()), day(today());

Then your expressions must be:

for the 2012: sum({$ <mydate = {'>=$(yearLess2start)<=$(yearLess2end)'}>} value)

for the 2013: sum({$ <mydate = {'>=$(yearLess1start)<=$(yearLess1end)'}>} value)

for the 2014: sum({$ <mydate = {'>=$(yearCurrentstart)<=$(yeaCurrentend)'}>} value)

Hope it helps

Re: Count Month

NavinReddy — Wed, 12 Mar 2014 08:13:15 GMT

Hi manish,

Is it possible to get with to dates 01-03-2011 to 12-03-2014

In between using set analysis with out writing any script

Best Regards,

Niranjan

Re: Count Month

jagan — Wed, 12 Mar 2014 08:37:36 GMT

Hi Niranjan,

Check this thread hope it helps you.

Calculating Months difference between two dates

Regards,

Jagan.

Re: Count Month

beeaj2011 — Wed, 12 Mar 2014 08:52:31 GMT

Hi Niru

I always define a continues month number in my script. So if your application starts with 2011 data I calculate the number by :

(Year(Date) - 2011 ) * 12 + Month(date) so it is very simpel to make calculations in your set analysis f.i :

Sum ({< PERIODKEY = {'> $(=$(vcurrYearMonthnum)-24) <= $(=$(vcurrYearMonthnum)-12) ' } ,F_PPP = {1,2} , T_PPP={3} >} COUNTER)

vcurrYearMonthnum has been calculated as mentioned above

Good luck

Re: Count Month

tresB — Wed, 12 Mar 2014 08:57:48 GMT

See the attached sample for a way in the front end without any data from back end.

edit: My sample takes year as input, you can modify accordingly for date input.

Re: Re: Count Month

NavinReddy — Wed, 12 Mar 2014 09:27:03 GMT

Hi Tresesco,

Thanks for your replay,

but im using 03-02-2011 format how can give this date

Thanks you so much

Best Regards,

Niranjan

Re: Count Month

MK_QSL — Wed, 12 Mar 2014 09:29:59 GMT

Dear Niru

You can try below....

=IF(Num(Month(Max(Date)))-Num(Month(Min(Date)))>=0,

((Num(Year(Max(Date)))-Num(Year(Min(Date))))*12)+Num(Month(Max(Date)))-Num(Month(Min(Date)))+1,

(NUM(Year(Max(Date))-Num(Year(Min(Date)))-1)*12)+13-Num(Month(Min(Date)))+Num(Month(Max(Date))))

Re: Count Month

tresB — Wed, 12 Mar 2014 09:35:10 GMT

Goto variable overview and change the definition of vStartNum : like :

Re: Count Month

Anonymous — Wed, 12 Mar 2014 09:35:24 GMT

Niru,

Here is the formulae you can use to get the months.

(Year(Today(2))*12 + Month(Today(2))) - (Year(Date#('01-03-2011','DD-MM-YYYY'))*12 + Month(Date#('01-03-2011','DD-MM-YYYY')))