Expression required

[#1]

Hello

I'm trying to do a simple division, using data from two different list boxes, which contain the same fields, but from different sources. One list box contains total number of properties per neighbourhood, the other list box contains number of complaints per neighbourhood. I wish to divide the number of complaints per neighbourhood figure by the total number of properties per neighbourhood, to give the average number of complaints per property for each neighbourhood. Simple to do on a calculator or on Excel!

Does anyone know which expression needs to be used - I have tried many different permutations, none of which gives the right answers.

Regards

Mike Hack

[martinpohl]

Hello Michael,

use sum(complaints per neighbourhood) / sum(total properties per neighbourhood)

Regards

[perumal_41]

HI,

Please provide sample application

Regards,

Perumal A

[#4]

Hi Martin

Thanks for your prompt reply, but that doesn’t work. I had tried it before, just tried it again and doesn’t give any results.

Any alternative suggestions please?

Regards

Mike Hack DMS, MMS (Dip)

Business Intelligence Officer

Business Excellence Team

City West Housing Trust

52 Regent Street

Eccles

M30 0BP

• 0161-605 7286

• michael.hack@citywest.org.uk<mailto:michael.hack@citywest.org.uk>

• www.citywesthousingtrust.org.uk<http://www.citywesthousingtrust.org.uk/>

[jagan]

Hi,

Try like this

Sum([complaints per neighbourhood]) / Sum([total number of properties per neighbourhood])

Replace [complaints per neighbourhood], [total number of properties per neighbourhood] with your actual field names.

Regards,

Jagan.

[martinpohl]

Doesn't give any results?

Did you use a chart/straight table with neighbourhood as dimension?

[jyothish8807]

Hi Michael,

Do you have a primary key connecting both the sheets?

Regards

KC

[#8]

Hi

This is the issue I feel. I’ll get our Qlikview programming expert to look at it when she’s back in work tomorrow.

Regards

Mike

[#9]

Hi Martin

Thanks for your reply. I feel the problem is using two separate tables, so I’ll wait until our in-house Qlikview expert returns to work tomorrow and she can perform a left join facility, or something similar.

Regards

Mike

[#10]

Thanks Jagan

Regards

Mike