topic Re: Help - WeekEnd or MonthEnd for daily projections in QlikView

Help - WeekEnd or MonthEnd for daily projections

joris_lansdaal — Sun, 29 May 2016 14:57:22 GMT

Hi All,

I've got a fairly simple challenge but don't know how to tackle it. My dataset contains a fact 'Projectie' .For every 'Datum' there's a projectie (projected stock level). I want to show a table with the projection for the end of the week or end of the month.

I want to use WeekYear or MonthYear from my mastercalender.

What approach can i best take?What set analysis do i use?

Sum({<ReplenishFlag={1}>}Projectie) will sum all value's instead of displaying one value.

Thanks for the help!

Re: Help - WeekEnd or MonthEnd for daily projections

swuehl — Sun, 29 May 2016 15:36:12 GMT

Maybe something like

=FirstSortedValue({<ReplenishFlag={1}>} Projectie, -DateField)

Re: Help - WeekEnd or MonthEnd for daily projections

joris_lansdaal — Sun, 29 May 2016 15:52:59 GMT

Thanks, swuehl!

This does work at BQS_ind level. However I need a sum for totals and sub totals in order to project/assess total future inventory.

Re: Help - WeekEnd or MonthEnd for daily projections

swuehl — Sun, 29 May 2016 16:01:22 GMT

What about creating a flag in your master calendar (for week end and month end separately), then use this flag in your set expression?

edit:

You can use GetCurrentField( DimensionGroupName ) in your expression if you need to check which dimension field, Week or Month is currently active in case you are using a dimension group, then branch into the expression using the correct set analysis.