topic Re: Set Analysis Expression using Interval in QlikView

Set Analysis Expression using Interval

ngosz4074 — Thu, 15 Sep 2016 11:49:08 GMT

Hello,

I'm trying to get a result using Set Analysis that would help filter my results using an Interval expression. What is the best option to use when the result in the expression below is less > -32?

expression I'm using:

Interval( [PREV_RESULT_TIME] - [RESULT_TIME], 'hh:mm')

Thanks in advance

Neal

Re: Set Analysis Expression using Interval

miguelbraga — Thu, 15 Sep 2016 16:16:54 GMT

Hey there,

Try this:

Supose you have a field called IntervalP in script like this:

Interval( [PREV_RESULT_TIME] - [RESULT_TIME], 'hh:mm') as IntervalP

Then you can add a expression like this:

=Aggr(

{$<IntervalP = {'<32' }>}

[your desired field goes here]

)

PS: Aggr -> function you must substitute to what you want

Hope this helps

Regards,

Re: Set Analysis Expression using Interval

sunny_talwar — Thu, 15 Sep 2016 17:15:23 GMT

less than -32 what? Hours or minutes or seconds? I think you need to provide more details if you would like us to help you better. May be provide a sample with expected output so that we can provide a working solution.

best,

Sunny

Re: Set Analysis Expression using Interval

ngosz4074 — Thu, 15 Sep 2016 17:38:18 GMT

I ended up switching the formula to an Aggr(Avg(RESULT_TIME)) with a dimension and it provides the result I am looking for.

Thanks for the help!