data must show with selection for MoM

[prma7799]

Dear All,

I have one chart in that I wrote attached expression

So data is showing two year sales

My requirement is when user select financial year 2016-15

then data data will show for year 15 and 16

if user select financial year 2015-14

then data data will show for year 15 and 14 like this

(means current year and last year total 24 bars will show.)

Note: vFY=Year(addyears(max([Posting Date]),-4))

PFA..

[tresesco]

Your date-fields-formats would matter while writing expression for the same. Try to create a sample qvw with representative data set where we can work upon to help you.

[tresesco]

Your master table creation is too complex with unnecessary (and probably confusing too) fields. Try to cleanse it. FinancialYear field is not a year field a date. And that is one of the reasons, making your set comparison fail. It would take a long time to analyse your this app and suggest right expression, and I am a bit lazy. . And yes, overlapping date ranges in your set could be another reason of failure too.

[prma7799]

Ok.

please give some alternate solution with existing master calendar  script.

Thanks

[tresesco]

There is no sales data for year 14,13 in your sample qvw.

[Anonymous]

Hi,

Please refer to the below link:

https://community.qlik.com/docs/DOC-9250

It will help.

Thanks.

[Mark_Little]

Hi,

The away i always approach a financial year like mentioned, is adding the information into your master calendar.

Then use that as a selector.

Mark

[prma7799]

Hi Mark / tresesco‌

Please ignore the previous file it was not proper.

PFA updated file.

Thanks

[tresesco]

Access denied !

[prma7799]

PFA