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

[Anonymous]

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
	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

[Gysbert_Wassenaar]

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.

[Anonymous]

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 😞

[Anonymous]

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 😞

[jagan]

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.

[Anonymous]

Hi All ,jagan

         PFA . Kindly help

Thanks in advance

[Gysbert_Wassenaar · Accepted solution]

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

[Anonymous]

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.

[Gysbert_Wassenaar]

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

[Anonymous]

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

🙂