Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

map: count

Hi Community,

just an extra.

On the map I'm making service count

Formula is: count(Services)

I would like to also display the number of vehicles used and foolishly I thought I would add the need with a ,

New Formula is:

count(Services, Vehicles) or count(Services) , count (Vehicles)

but it doesn't work.

Do you have a suggestion?

Immagine.png

1 Reply
arvind654
Honored Contributor II

Re: map: count

In Qlik Sense map unfortunately you cannot. As it allows only single expression.

You can +,-,/ the expression or use Set analysis but it will not show you multiple values.

'<b> Service</b>= ' & Count(Service)& '<br>' &

'<b> Vehicles</b>= ' & Count(Vehicles)& '<br>'

or

'Service : ' & Count(Service)& chr(10)

& 'Vehicles: ' & Count(Vehicles)& chr(10)

Usually this will work but it doesn't in Map you've