Can't get one weeks missing data to show in Pivot Table

[#1]

I have a weekly report that must only contain the data from one week.  The problem is that certain products are missing data for particular weeks and only occasionally have a value in them say once per month.  I need [Pairs per Package] to show up in the pivot table every single week without fail to simplify the maintenence of my reports (ie make them dummy proof).  I'm using three seperate dimensions and I've tried to make them show all values with no success.

I have tried using a set analysis below, but it makes no difference from just putting [Pairs per Package] in there.  It gives the set analysis 53 weeks worth of data to look at, but it won't add back the missing data.  What am I doing wrong?

MAX({< [Production Date] = {'>=$(=(v_LastWeekEnding))<=$(=(v_OneYearOutWeekEnding))'} >} [Pairs per Package])

[#2]

the

max(if([Production Date]>=v_LastWeekEnding and Production Date]<=v_OneYearOutWeekEnding,[Pairs per Package],0)) expression didn't work.

The binary fix you posted shows red squiggly lines under the second to last line that says:

Load Product,  [Production Date], PairsperPackage [Pairs per Package]  Resident Temp;

I underlined the part with the red squiggly lines that indicate a syntax error.  Is that section correct and the error check is a false alarm?  I know that happens from time to time, but I'm unsure in this case.

Regardless of outcome Kiran, I want to thank you for taking the time to help me.

Scott

[#3]

I am sorry it should be:

Load Product, [Production Date], PairsperPackage as [Pairs per Package]  Resident Temp;

[#4]

Reading your first post "it makes no difference", the data may me such that max value of pairs per package is during last week. I recommened we try with count function, which must tell us how many rows are considered with and without the set analysis. If there is a difference there is no question of anything being wrong with the set analysis.

Singing off for the day, will sure solve this by tomorrow.

Regards,

Kiran.

[#5]

The Max value happens randomly in the future as well as the past.  I think the one particular indicator of the error that I use to check if there has been a change has the max value within a month or so.  The problem is that there is no record of the product at all when I'm pulling the data for the current week ending date, so the pivot table doesn't show it or try to find the max value that it has in the Pairs Per Package field.  It just ignores it entirely as if it never existed.

[#6]

Thats how qlikview behaves. What is expected when the product has no data during last week? Should the value be zero or show its most recent transaction or anything else?

[#7]

I want it to show the maximum value for the field regardless of date (not zero) and I need it to show that same value every week even if there are no other data fields (expressions) to display.

[#8]

Can you give a sample data set masking the values etc., and expected output? I am not able to envision your requirement exactly.

Regards,

Kiran.