Need Last two weeks or three weeks of Quarter

[prasanth_nossam]

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

[YoussefBelloum]

Hi,

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

[prasanth_nossam]

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

[imhappiee]

Hi

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