Exclude last date in dimension

[jlampard40]

Hi - I have the following expression:

=Count({<Activity_or_Demand={'Demand'}>}Event_Key)

and using dimension called 'Financial_Year_Week'

This will show nicely a count of event keys per financial year week.  However, as this data is updated on a daily basis, I want to exclude the latest week as it will only be partial data until the following week begins.  How can I modify my expression to exclude the latest financial year week?  In this case (at the moment) I will want to exclude 'FY19/20 34' i.e. week 34 of FY 19/20.  However, I don't want to keep having to change the expression!  Would be nice to have a script which simply excludes the latest (MAX?) financial_year_week on a weekly basis.

Many thanks guys!

Rgds

[Anil_Babu_Samineni]

1) You want to exclude the Max week of data in the entire model

2) Same for Max Financial Year data also?

[jlampard40]

I just want to exclude the MAX week in relation to the field 'Financial_Year_Week'.

Rgds

[Brett_Bleess]

Best I have to try to help you move things forward is a Design Blog post:

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

Here is another related to dates in set analysis:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Hopefully between those two, they may help you get things sorted until one of the more brilliant folks out here other than me can have a further look for you.

Regards,
Brett

[qliksus]

If you want to exclude just one week you can try the below 

=Count({<Activity_or_Demand={'Demand'} , Week=-{'$(=max({<year={"=max(year)"}>}week))'}>}Event_Key)