topic Interval Match in QlikView

Interval Match

jmonroe918 — Fri, 21 Mar 2014 18:30:36 GMT

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

Re: Interval Match

srchilukoori — Fri, 21 Mar 2014 18:48:12 GMT

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

Re: Interval Match

jmonroe918 — Fri, 21 Mar 2014 18:50:29 GMT

I'm sorry you lost me.

Jeff

Re: Interval Match

srchilukoori — Fri, 21 Mar 2014 18:51:07 GMT

Can you upload a sample Qvw

Re: Re: Interval Match

jmonroe918 — Fri, 21 Mar 2014 18:55:09 GMT

Sorry, I thought I did attach it.

Here it is.

Thanks.

Jeff

Re: Re: Re: Interval Match

srchilukoori — Fri, 21 Mar 2014 19:30:59 GMT

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

Re: Interval Match

jmonroe918 — Fri, 21 Mar 2014 19:42:28 GMT

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

Re: Re: Interval Match

srchilukoori — Fri, 21 Mar 2014 20:08:54 GMT

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.