topic Re: Shortages in QlikView

Shortages

dseelam — Tue, 14 Mar 2017 18:29:41 GMT

Hello All,

I am working on inventory DB, would like to know my shortages in % for next 10 weeks starting today(), it doest matter with datw it should be always starting today

Worked on scenario in attached samples but it is giving me shortages from 10th week to rest of the year as it is coming from master calendar

Thanks D

Re: Shortages

aarkay29 — Tue, 14 Mar 2017 19:14:09 GMT

you need to use something like this set analysis

=(sum({$ <WKDT = {">=$(=today())<=$(=Date(WeekEnd(Today()+9*7)))"}>} ASCP.DMND)-sum({$ <WKDT = {">=$(=today())<=$(=Date(WeekEnd(Today()+9*7)))"} >} ASCP.ON_HAND))/(sum({$ <WKDT = {">=$(=today())<=$(=Date(WeekEnd(Today()+9*7)))"}>} ASCP.DMND)*100)

Re: Shortages

dseelam — Tue, 14 Mar 2017 19:52:27 GMT

Aar,

what if the WKDT are only start date of the week for example WKDT is only bringing every Monday from source

Thanks,

Re: Shortages

aarkay29 — Tue, 14 Mar 2017 19:57:57 GMT

May be this

=(sum({$ <WKDT = {">=$(=WeekStart(today()))<$(=Date(WeekStart(Today()+10*7)))"}>} ASCP.DMND)-sum({$ <WKDT = {">=$(=weekStart(today()))<=$(=Date(WeekStart(Today()+10*7)))"} >} ASCP.ON_HAND))/(sum({$ <WKDT = {">=$(=WeekStart(today()))<=$(=Date(WeekStart(Today()+10*7)))"}>} ASCP.DMND)*100)

Re: Shortages

dseelam — Tue, 14 Mar 2017 20:15:11 GMT

Aar,

its not working with only week start dates from source

Re: Shortages

aarkay29 — Tue, 14 Mar 2017 20:28:43 GMT

I don't clearly understand what you are looking for

but the expression seems to be working

PFA

Re: Shortages

dseelam — Tue, 14 Mar 2017 20:53:26 GMT

Aar,

My bad you are right some how my source data is giving blanks

Thanks,