topic Re: expression help in QlikView

expression help

Wed, 25 Jun 2014 10:48:43 GMT

Hi,

We have the following expression on a Qlikmap which is working:

[Address Concat] &' '& [Description] &' '& Count([Job No])

however would like it have text before Count Job No to explain what it is. So ideally like the pop up box to read:

Address : xxxx

Repair Description: xxx

Number of repairs in property: xxx

Can anyone help?

alexandros17 — Wed, 25 Jun 2014 10:55:21 GMT

[Address Concat] &' '& [Description] &' '& 'Number of repairs in property:' & Count([Job No])

Align text on the left.

its_anandrjs — Wed, 25 Jun 2014 10:59:20 GMT

Some little change in expression have a look

[Address Concat] & ' : ' &' '&

[Description] & ' : ' &' '&

'Number of repairs in property: '&Count([Job No])