topic Re: expression help in QlikView

expression help

Thu, 03 Sep 2015 14:32:00 GMT

Hi,

Trying to create an expression in a a text box that will show number of properties that have a value of less than £5000.

Here is expression we currently have but its not working at all:

= Count([Address] [NPV Total] <=-'£5000.00')

Please can someone help?

Chris

Thu, 03 Sep 2015 14:37:07 GMT

Count( {<[NPV Total]={"<5000"}>} [Address])

sinanozdemir — Thu, 03 Sep 2015 14:38:55 GMT

Hi Chris,

Try this:

Count({<[NPV Total] = {"<=£5000.00"}>}[Address] )

Thu, 03 Sep 2015 15:02:03 GMT

Hi,

Can you help with the above. We want the same expression but to cover situation where its between 2 values: -£4999 - £4999.

I tried this but it doesn't work?:

=Count( {<[NPV Total]={>='-£4999.00' AND [NPV Total]<='£4999.00'}>} [Address])

Chris

settu_periasamy — Thu, 03 Sep 2015 15:05:13 GMT

Try this

=Count( {<[NPV Total]={>='-£4999.00'<='£4999.00'}>} [Address])

Thu, 03 Sep 2015 15:09:31 GMT

Hi,

Unfortunately no..its says 'error in set modifier ad hoc element list.

Underline in red on }>} [Address]

Chris

settu_periasamy — Thu, 03 Sep 2015 15:47:21 GMT

May be try this

=Count({<[NPV Total]={">=-4999<=4999"}>} [Address])