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
you need to create the "in transit" flag and limit the load or just create the flag ?
i need to create the "in transit" flag for those weeks(based on weeksdate)
Actually i need to minus those weeks subquantity value
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