Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arusanah
Contributor

help with expression

Hi ,

I am using SVG Map. my requirement is to display count of CUST_ID as % as well as #.  to display % , I'm using following expression.

Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'###0')&'%',

But  when I add second measure  count( distinct(CUST_ID) ) to show count as number , my visualization gets disabled.

How can I show both outputs in single SVG . Really appreciate your help!!

3 Replies
Not applicable

Re: help with expression

Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'#,##0.00%')

abhijain
New Contributor III

Re: help with expression

Hi,

in the map you can simply use the expression as

=num(Count([CUST_ID])/count( all [CUST_ID]),'#,##0.00%')

or

=num(Count([CUST_ID])/count( total [CUST_ID]),'#,##0.00%')

amit_saini
Honored Contributor III

Re: help with expression

Hi,

It has to be:

Num(Count([CUST_ID]) /Count(Distinct([Cust_ID])),'###0%')

Thanks,
AS

Community Browser