topic Please correct the expression in QlikView

Please correct the expression

Tue, 15 Mar 2011 13:15:35 GMT

Hi,

I have this expression in my bar chart, but not working as i expect.

Avg({<OFFER_TAT_DIFF-={'-1'}>} OFFER_TAT_DIFF)

That is, I want my chart to show the avg of OFFER_TAT_DIFF avoiding those values where OFFER_TAT_DIFF which is -1.

But even after giving the clause in expression my bar chart comes with -1 values.

Can anyone help me in reframing the expression.

Tue, 15 Mar 2011 13:29:23 GMT

try like this.. but am not sure..

=Avg(aggr({<OFFER_TAT_DIFF-={'-1'}>} OFFER_TAT_DIFF))

Regards

A'run'

Tue, 15 Mar 2011 14:16:40 GMT

I think your expression is right.

Wed, 16 Mar 2011 08:23:57 GMT

Actually the expression was correct.

The problem was that negative values other than -1 also used to come ...

So I actually want to restrict all values that are less than 0.

Can anyone reframe the expression ...am getting an issue with ">" sign as it is already a syntax of expression..

Wed, 16 Mar 2011 08:33:05 GMT

Try

=Avg({<OFFER_TAT_DIFF ={">=0"}>} OFFER_TAT_DIFF)

Regards

Anders

Wed, 16 Mar 2011 09:33:38 GMT

Hi,

Pls try below one.

Avg({<OFFER_TAT_DIFF-={'<>-1'}>} OFFER_TAT_DIFF)

Hope it will work.

Regards,

Napolean.

Wed, 16 Mar 2011 10:01:15 GMT

Thanks