topic Re: Current/ Previous Month/Quarter in QlikView

Current/ Previous Month/Quarter

Thu, 19 Feb 2015 14:35:59 GMT

Hi,

I have a Excel source with the time Dims with other Measures and calc Fields as below;

I want to dertermine the Latest and Previous Month and Latest and Previous Quarter calculation on a Chart.

Any help appreciated !

Thanks !

Re: Current/ Previous Month/Quarter

buzzy996 — Thu, 19 Feb 2015 15:40:38 GMT

try tis

Current Month

=num(sum({$} Measure), '$#,##0;($#,##0)')

Previous Month

sum({$<Year = {$(=only(Year) - $(=if(only(Month) = 1, 1, 0)))}, Month = {$(=month(addmonths(MonthYear, -1)))}>} Measure)

current QTR

=num(sum({$<Year = {$(=only(Year))}, Quarter = {$(=only(Quarter))}, Month = {"<=$(=max(Month))"}>} Measure), '$#,##0;($#,##0)')

Re: Current/ Previous Month/Quarter

sunny_talwar — Thu, 19 Feb 2015 15:52:48 GMT

Personally I would flag the data in the script and use that in my set analysis statement o simplify things. A sample qvw would be helpful in order to explain it.

Best,