topic Re: Count ID by month in QlikView

Count ID by month

Tue, 16 Sep 2014 13:41:40 GMT

Hi All,

I have date field (DD/MM/YYYY HH:MM:SS:YYY), and I have calculating month in vMonth, how do I get : TextCount (ID) based on my vMonth variable?

Thanks,

Lakshmi.

Re: Count ID by month

MK_QSL — Tue, 16 Sep 2014 13:48:30 GMT

Lakshmi, didnt understand from your explanation properly... can you elaborate little more please?

Re: Count ID by month

Anonymous — Tue, 16 Sep 2014 14:00:43 GMT

Please elaborate more on this post

Re: Count ID by month

fabio_vallone — Tue, 16 Sep 2014 14:04:06 GMT

Instead vMonth, try this:

Dimension: =Date(Monthstart(<DATE FIELD>), 'MMM/yy')

Expression: =TextCount(ID)

Re: Count ID by month

Tue, 16 Sep 2014 14:05:35 GMT

Hi Manish,

I have 4 text boxes, 4 variables (vMth1, vMth2, vMth3, vMth4)

In table I have 2 fields: Date, Count.

In the text boxs, I have to show TextCount (ID) based on the vMth.

e.g. vMth = Apr; TextCount (ID) = 20

vMth1 = Mar; TextCount (ID) = 25

vMth2 = Feb; TextCount (ID) = 5

vMth3 = Jan; TextCount (ID) = 30

Re: Count ID by month

Tue, 16 Sep 2014 14:11:17 GMT

Laxmi Do you want only month from that date field values???

Re: Count ID by month

Tue, 16 Sep 2014 14:12:24 GMT

HI Fabio,

My Diminesion should be Status (another field)

Is:- Date(Monthstart(<DATE FIELD>), 'MMM/yy')

will give total records of that month for different status? the expression telling that Month start.

Re: Count ID by month

fabio_vallone — Tue, 16 Sep 2014 14:20:19 GMT

The Dimension Date(Month Start(<DATE FIELD>), 'MMM/yy') ignore days and hours and cumulate TextCount(ID) for each Month and Year. Using this dimension AND the "Status" Dimension you will have Bars or lines "by Month/Year and Status".

Re: Count ID by month

Tue, 16 Sep 2014 14:24:29 GMT

Hi Fabio,

Thanks for clarification.

this is working for me.

=TextCount({<Month = {'$_3(vMonth)'}, Year = {'$(vYear)'}>}ID)