Re: MonthYear MonthYear - 1 in Bar Chart - Qlik Community

Anonymous · ‎2013-09-16

All,

I am trying to create a bar chart that has 1 dimension MonthYear with no selections. I want to show quantity of current month and last year same month.

Any advice on the formulas to do so?

Thank you!

Gysbert_Wassenaar · ‎2013-09-16

If you're using MonthYear as a dimension and want to show each MonthYear along with its corresponding month from the year before you neeed an AsOf table that links each MonthYear value with it corresponding year-before month. See this document: Calculating rolling n-period totals, averages or other aggregations

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2013-09-16

Hi

Try this in your expression

=SUM({<[Date Field]={">=$(=MonthStart((Max([Date Field])))<=$(=MonthEnd((Max([Date Field])))"},Year=,Month=,Quarter=>

+

<[Date Field]={">=$(=MonthStart((Max([Order Date])),-12))<=$(=MonthEnd((Max([Date Field]),-12))"},Year=,Month=,Quarter=>}Fieldname)

-12 here specifies the same moth in previous year

Anonymous · ‎2013-09-16

This is not working... I am only using MonthYear as my dimension.

Report Inappropriate Content · ‎2013-09-16

Hi,

This is working for month year dimension too if possible pls post your sample file

Anonymous · ‎2013-09-16

here is a screen shot

Report Inappropriate Content · ‎2013-09-16

Can you post a sample app with small data?

Anonymous · ‎2013-09-16

Here is a sample file.