topic Re: Count month in QlikView

Count month

Fri, 27 Jun 2014 05:46:48 GMT

Hello all

I want to count number of months in current financial year as well as in previous year (though its fixed number 12),how do i do that??

amit_saini — Fri, 27 Jun 2014 05:50:01 GMT

Rohit,

Follow this:

Thanks,
AS

Fri, 27 Jun 2014 05:56:53 GMT

Hi,

You can use 'set analysis' or 'If' condition to get the result.

Example: If Condition ;

For Current Year : Count(if(Year_col=Year(Today()),Month_col))

For PreviousYear : Count(if(Year_col=Year(Today())-1,Month_col))

Regards.

SunilChauhan — Fri, 27 Jun 2014 06:04:50 GMT

count( {<FinYear={">=$(=max(FinYear)-1)"}>} distinct Monthfield) for if you want combined

else

For Current Year : Count({<FinYear={$(=Max(Finyear))}>} Monthfield)

For PreviousYear :Count({<FinYear={$(=Max(Finyear)-1)}>} Monthfield)

you can calculate financial Year

MonthName(yearfield,0,4)

hope this helps

jagan — Fri, 27 Jun 2014 06:18:27 GMT

Hi Rohit,

Try like this

For Current Year :

Count({<MonthDimensionName=, YearDimensionName={$(=Max(YearDimensionName))}>} DISTINCT MonthDimensionName)

For PreviousYear :

Count({<MonthDimensionName=,YearDimensionName={$(=Max(YearDimensionName)-1)}>} DISTINCT MonthDimensionName)

Regards,

Jagan.

Fri, 27 Jun 2014 13:05:32 GMT

Thank you jagan