topic Re: help with an expression in QlikView

help with an expression

Sun, 25 Jan 2015 20:59:34 GMT

Hi,

Please see attached. Need an expression which we can use on text boxes and charts.

We need the text box to count addressses but only in four neighbourhoods: Amblecote, Eccles & Weaste, Moss Vale and Clifton Green.

I was working on this but its not working:

=Count([Tenancy No]='Moss Vale')

We have a pilot running in these areas. Struggling with how this should be shown in the expression.

Chris

its_anandrjs — Sun, 25 Jan 2015 21:12:38 GMT

Hi,

For four neighbors try in text box with set analysis expression and hard code the four strings in the count expression.

=Count({<Neighbourhood={'Amblecote','Eccles & Weaste','Moss Vale','Clifton Green'}>} [Tenancy No])

Regards

Anand

maxgro — Sun, 25 Jan 2015 21:44:23 GMT

Sun, 25 Jan 2015 22:00:03 GMT

Hi,

Thanks for your responses. Very helpful.

The last stage is trying to compre these four neighbourhoods against the others.

So we have this to select the four neighbourhoods:

Count({<Neighbourhood={'Amblecote','Eccles & Weaste','Moss Vale','Clifton Green'}>} [Tenancy No])

We also have the following the get an average which works.

Num(Avg(Tenancy_Length_Days),'#,###.##')

To get the detail we want, i.e average arrears in the four neighbourhoods can you suggest what the expression would be?

Chris

MarcoWedel — Mon, 26 Jan 2015 00:07:03 GMT

Num(Avg({$<Neighbourhood={'Amblecote','Eccles & Weaste','Moss Vale','Clifton Green'}>} Tenancy_Length_Days),'#,###.##')

Mon, 26 Jan 2015 07:41:15 GMT

Thanks so much

MarcoWedel — Mon, 26 Jan 2015 14:50:25 GMT

You're welcome

Regards

Marco