Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasanth_nossam
Contributor
Contributor

Need Last two weeks or three weeks of Quarter

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



3 Replies
YoussefBelloum
Champion
Champion

Hi,

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

prasanth_nossam
Contributor
Contributor
Author

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
Contributor III
Contributor III

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