Interval Match

[jmonroe918]

Hello:

I am trying to display a number in a Text Object based on a calcuation (sum(total complaints)/sum(total shipments) *1000000), I want to look this calculation result in a in-line table, so that if it falls between the low and high parameters, the figure in the "Sigma" column will display.

It is probably easiest when viewed in the attachd qvw file.

I'm not sure if interval match is the answer. I think an series of if then statements would be huge, considering the size of the lookup table.

Thanks.

Jeff

[srchilukoori]

try to aggregate the data in the script and use the interval match with Inline tables.

[jmonroe918]

I'm sorry you lost me.

Jeff

[srchilukoori]

Can you upload a sample Qvw

[jmonroe918]

Sorry, I thought I did attach it.

Here it is.

Thanks.

Jeff

[srchilukoori]

Check the attached app. Let me know if this is what you are trying to implement.

[jmonroe918]

It's sort of there. The one thing I need from all of this is an overall CPM (sum of all Complaints/sum of all Shipments * 1000000) displayed in a Text Object and then where in the Sigma Table that CPM lies, also displayed in a Text Object.

Jeff

[srchilukoori]

The overall value of sigma is presented in the new table.

The previous version evaluated the Sigma and yield for a Location in a given week of Year/Period.