interval statement in if clause

Fri, 02 Sep 2011 18:23:38 GMT

I have an interval statement that works fine on it's own but when I put it into an if clause it will give me days rather than minutes

Median (If(MeasureDenominator = 1 and MeasureGroup = 'ED', Interval(MeasureNumerator, 'm'))) will give me an answer in minutes but

If(MeasureGroup = 'ED', Median(If(MeasureDenominator = 1, Interval(MeasureNumerator, 'm'))), Sum(IF(MeasureDenominator = 1, MeasureNumerator))) gives me the correct number for the sum option, but if it is the interval it comes out in days not minutes.

Any ideas why this is not working? I'm wondering if I need to use set analysis, but I was not able to get the syntax right for that. Any help would be greatly appreciated.

interval statement in if clause

rwunderlich — Fri, 02 Sep 2011 21:30:33 GMT

You are mixing two different display formats -- Interval and Numeric -- in the same field. This is not possible, QV is choosing the numeric format for all values.

You can preserve the interval minutes formatting by converting to strings. Add a text() function around the interval(). You may have to do the same for the Sum(). You will lose the correct internal numeric values, which may be acceptable for your app.

-Rob

http://robwunderlich.com

topic interval statement in if clause in QlikView

interval statement in if clause

interval statement in if clause