topic Re: Monthly Total in QlikView

Monthly Total

chris_munns — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Having an issue calculation a monthly total.

I have a table with the number of members by JoinDate. Count of the number of members who joined on that day and a cumulative count;

Next step is to populate the table below;

The table is showing the number of members who joined in the month, regardless of year, of course i can include an expression to provide the current year/month values. This is not what I am after.

The expression for the count of members by month for FY17 is where I would like to start; Jul - 139,295 through to Jan - 144,790 (as per the table above).

So, i am starting with :-

=num( sum( Member_Count) ,'#,###,###')

Grateful for any guidance.

Thanks,

Chris

Re: Monthly Total

sdmech81 — Tue, 21 Feb 2017 05:50:23 GMT

May be use pivote table and there go to calculated dimension and say:

=Month(JoinDate)

Then put your expression >>plss try

Re: Monthly Total

muthukumar77 — Tue, 21 Feb 2017 05:57:36 GMT

Hi,

you can use Month(JoinDate) as Month in script.

then use Month column in pivot table.

Re: Monthly Total

adamdavi3s — Tue, 21 Feb 2017 08:57:08 GMT

Hi CHris,

I think what you're looking for is something like:

=num( sum( {<year(JoinDate)={"=$(=year(today())"}>}Member_Count) ,'#,###,###')

However I would make life much easier for yourself and create a master calendar for joindate as you can then set some flags etc to pick up the current year