topic Re: Calculation of FY-MOMTD(Month on Month Till date) in QlikView

Calculation of FY-MOMTD(Month on Month Till date)

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

Hi All,

Is it possible to build a table like this in Qlik? Only in current month dimension, we want T-2 and T-1 columns along with total amount and in rest months we want total amount of that particular month.

FY-MOMTD
Call Centre (Vendors)	Mar-16						Feb-16		Jan-16		Dec-15
Call Centre (Vendors)	Collection till T-2	NOP collected Till T-2	Collection on T-1	NOP Collected on T-1	Total Collections (Rs. Crs)	NOP Collected	Total Collections (Rs. Crs)	NOP Collected	Total Collections (Rs. Crs)	NOP Collected	Total Collections (Rs. Crs)	NOP Collected
E-NXT	2.65		0.50		3.15		8.94		7.50		6.87
CAMS	3.64		0.45		4.09		13.53		12.15		9.78
ATS	5.29		0.51		5.80		20.91		20.08		14.33
CNX	2.15		0.30		2.44		7.62		9.60		5.69
Grand Total	13.72		1.76		15.48		51.00		49.33		36.67

Re: Calculation of FY-MOMTD(Month on Month Till date)

Gysbert_Wassenaar — Wed, 23 Mar 2016 16:20:42 GMT

Probably. But it will likely be very complicated. It's a lot easier to use two charts: one for the current month and one for the previous months.

Re: Calculation of FY-MOMTD(Month on Month Till date)

Anonymous — Thu, 24 Mar 2016 06:10:42 GMT

Hi Gysbert,

User wants current and previous months in single chart, Could you suggest any way to suggest how to achieve this, Around 30 reports need same layout 😞

Re: Calculation of FY-MOMTD(Month on Month Till date)

Anonymous — Thu, 24 Mar 2016 06:10:58 GMT

Hi ,

User wants current and previous months in single chart, Could you suggest any way to suggest how to achieve this, Around 30 reports need same layout 😞

Re: Calculation of FY-MOMTD(Month on Month Till date)

jagan — Thu, 24 Mar 2016 06:28:21 GMT

Hi,

It is bit difficult you have to use some dummy dimension mapped to month, not that much easy but possible. Attach some sample data so that it is easier.

Regards,

Jagan.

Re: Calculation of FY-MOMTD(Month on Month Till date)

Anonymous — Thu, 24 Mar 2016 08:00:30 GMT

Hi All ,jagan

PFA . Kindly help

Thanks in advance

Re: Calculation of FY-MOMTD(Month on Month Till date)

Gysbert_Wassenaar — Thu, 24 Mar 2016 09:48:49 GMT

See attached example. Perhaps you can do something like that.

Re: Calculation of FY-MOMTD(Month on Month Till date)

Anonymous — Thu, 24 Mar 2016 10:47:55 GMT

Hi Gysbert,

Thanks for the help, but in T-1 column I need count of id which are related (today's date - 1), not the previous month count. and similarly T-2 is count of id from starting of the current month to (today's date-2), Total Count is total count of that month.

Re: Calculation of FY-MOMTD(Month on Month Till date)

Gysbert_Wassenaar — Thu, 24 Mar 2016 11:22:37 GMT

Days, months, whatever. I've showed you the technique. Get creative.

Re: Calculation of FY-MOMTD(Month on Month Till date)

Anonymous — Thu, 24 Mar 2016 13:38:10 GMT

Thank you so much Gysbert, I just changed few things and I got the result as I wanted.

🙂