topic Re: Expression required in QlikView

Expression required

Mon, 22 Sep 2014 09:10:54 GMT

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

Re: Expression required

martinpohl — Mon, 22 Sep 2014 09:14:36 GMT

Hello Michael,

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

Regards

Re: Expression required

perumal_41 — Mon, 22 Sep 2014 09:18:32 GMT

HI,

Please provide sample application

Regards,

Perumal A

Re: Expression required

Mon, 22 Sep 2014 09:23:48 GMT

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/>

Re: Expression required

jagan — Mon, 22 Sep 2014 09:25:47 GMT

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.

Re: Expression required

martinpohl — Mon, 22 Sep 2014 09:31:51 GMT

Doesn't give any results?

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

Re: Expression required

jyothish8807 — Mon, 22 Sep 2014 09:35:26 GMT

Hi Michael,

Do you have a primary key connecting both the sheets?

Regards

Re: Expression required

Mon, 22 Sep 2014 09:46:00 GMT

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

Re: Expression required

Mon, 22 Sep 2014 09:47:12 GMT

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

Re: Expression required

Mon, 22 Sep 2014 09:47:14 GMT

Thanks Jagan

Regards

Mike

Re: Expression required

Mon, 22 Sep 2014 09:48:24 GMT

Thanks for all the replies.

Think we have located the issue now.

Regards

Mike