topic expression in QlikView

expression

Mon, 03 Mar 2014 16:33:44 GMT

Hi all,

We are looking to try and use a text box or statistics box that will get us a certain answer.

We want the text box/stats box to tell us number of properties in the block. Curently when we select the box it includes all properties. So on the example below it says 6; however, in reality it is 5. Aberdeen is the 'block' itslef, not a property within it. So thinking solution is an expression in the text/stats box. Here is the data below. As the block and UPRN are unique thinking we could do soemthing her for example 'count if block = yes.'

Can anyone help with the expression?

Address Block UPRN

1 Aberdeen - 10703101

2 Aberdeen - 10703101

3 Aberdeen - 10703101

4 Aberdeen - 10703101

5 Aberdeen - 10703101

Aberdeen Yes 10703101

Chris

Re: expression

Mon, 03 Mar 2014 16:46:21 GMT

Chris,

Try this:

Count(Distinct {<Block = {"<> Yes"} > UPRN}

Distinct or NoDistinct accroding the unicity or not of the field

Fabrice

Re: expression

Mon, 03 Mar 2014 17:01:35 GMT

Hi Fabrice,

Doesn't seem to like it.

Says 'error in expression'

Chris

Re: expression

Aurelien_Martinez — Mon, 03 Mar 2014 17:03:48 GMT

Count(Distinct {<Block -= {'Yes'} >} UPRN}

Re: expression

Mon, 03 Mar 2014 17:10:44 GMT

It likes the expression; however, gives a result of 1. The result I need is 5 which is any of the properties where block = '-' or null

Chris

Re: expression

Mon, 03 Mar 2014 17:16:10 GMT

=count(DISTINCT {1<UPRN = {"=len(trim(Block)) =0"} >} UPRN)

should be better

Fabrice