topic Need Last two weeks or three weeks of Quarter in QlikView

Need Last two weeks or three weeks of Quarter

prasanth_nossam — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am new to qlikview, i am trying to solve one logic but output not coming as expected.

attaching sample data please help on this.

If there are 5 Weeks in the last month of the Quarter, consider 3 Weeks Quantity as “In Transit” and if there are 4 Weeks, consider 2 Weeks Quantity as “In Transit”.

here we need to consider first two or three weeks of month, means those are in “In Transit”

Thanks in Advance

Re: Need Last two weeks or three weeks of Quarter

YoussefBelloum — Mon, 02 Jul 2018 12:32:18 GMT

Hi,

you need to create the "in transit" flag and limit the load or just create the flag ?

Re: Need Last two weeks or three weeks of Quarter

prasanth_nossam — Mon, 02 Jul 2018 14:51:12 GMT

Hi Youssef,

i need to create the "in transit" flag for those weeks(based on weeksdate)

Actually i need to minus those weeks subquantity value

Re: Need Last two weeks or three weeks of Quarter

imhappiee — Mon, 02 Jul 2018 15:16:20 GMT

Try loading the Max quarter to a table in your case Q3

Then load this table to find weeks count , based on the distincnt count of weeks you can write a condiion to flat In transit in a different table by taking the load from the Quarter filtered table

Set your condition if the count is 5 then set a flag In transit for the latest 3 weeks

if it 4 then set a flag for latest 2 weeks

Hope this gave you the logic to work

Anand