topic Analyisis in QlikView

Analyisis

dseelam — Tue, 14 Mar 2017 02:08:56 GMT

Hello Friends,

Need help with below scenario, I am working on Inventory dashboard

I need to calculate Inventory shortage which is (DMND-ONHAND/DMND*100) in percentage as of today give me shortages starting 10 12 14 weeks so on up to 15 weeks

I don't know best way to show it and how to calculate weeks as of day starting from 10th week ??

I have WKDT date in my data model

Thanks,

Re: Analyisis

Anil_Babu_Samineni — Tue, 14 Mar 2017 03:27:26 GMT

In theoretically we can do with WKDT = {Week(WKDT) >= 10}

=sum( {$ <WKDT ={"=Week(WKDT) >= 10"}>} DMND-ONHAND/DMND*100)

=(sum( {$ <WKDT ={"=Week(WKDT) >= 10"}>} DMND)-sum( {$ <WKDT ={"=Week(WKDT) >= 10"}>} ONHAND)/sum( {$ <WKDT ={"=Week(WKDT) >= 10"}>} DMND)*100)

Do this in script with Week(WKDT) as Week

=sum( {$ <Week = {">=10"} >} DMND-ONHAND/DMND*100)

Re: Analyisis

dseelam — Tue, 14 Mar 2017 17:01:38 GMT

Anil,

your query is giving me results but they are percentage from week 10 for whole year, I need to see results from today to week 10 from now depending on WKDT

THANKS

Re: Analyisis

Anil_Babu_Samineni — Wed, 15 Mar 2017 05:00:47 GMT

Can you describe more with sample week field and scrum Dates. Then only we came to know what you are trying there?

You can try something like below, But this is not make sense if we have >= 10th week.

=sum( {$ <Week = {">=10 <= Week(Today())"} >} DMND-ONHAND/DMND*100)