Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Re: How to change the values in measure as percentage?

OR not AND , a TYPE can't be OPEN and SIGN UP at the same time; or would work :

Not applicable

Re: How to change the values in measure as percentage?

No it's not working for both, can u send me formula

Partner
Partner

Re: How to change the values in measure as percentage?

It's working for me  :

Type='SIGN-UP' or Type='OPEN'


not

Type='SIGN-UP' or 'OPEN'


if(Type='SIGN-UP' or Type='OPEN' ,num(sum(Sum),'##0,00'), num((sum(Sum)/sum(total Sum))*100,'##0,00%'))

Capture.PNG

Not applicable

Re: How to change the values in measure as percentage?

Sorry it was my mistake,it's working fine,,,,thank u so much