Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for
Did you mean:
Not applicable

## How to change the values in measure as percentage?

Hello All,

From the above graph

In delivered emails i have values but in open rate i need those values should be in percentage type as well as in signup rate too.

1 Solution

Accepted Solutions
MVP

I found out 2 "solutions"; I don't know if it's appealing enough though..
1st one:

in the same graphic, having some dimensions having sum(Sum) and others as % (but you'll have to know what's the % because I couldn't show the % sign):

Measure :

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

result:

2) you'll have to use a combined chart and thus, you can't have 2 dimensions in your chart but only ONLY hiearchic dimension :

and create 2 master measures:

Now, in your chart, use these dimension and measures :

result:

I click on open and confirm : I'll have sum(Sum) by segments of type open:

see the attached app

You can also have the information of the % for juste the Type OPEN for example:

Type to =Type& ' '&aggr( if(Type='OPEN',num((sum(Sum)/sum(total Sum))*100,'##0,00%')),Type)

Segment_Name to =Segment_Name& ' '&aggr( if(Type='OPEN',num((sum(Sum)/sum(total Sum))*100,'##0,00%')),Segment_Name,Type)

result :

13 Replies
Specialist III

I think this is not possible , but if you hover on the bars you will see the Value and Share

MVP

Unfortunately, it's not possible to control what's being seen in the pop up in Qlik Sense; the only way to do it is to color by expression, and the expression would be the %; in that case, when you hover on it, you'll see the percentage.

mto‌, in qlikView, we have the possibility to control what's being seen when we hover over a dimension; we could add a measure, make it invisible and it will only appear when we hover over an object.
Is such a possiblity or another direct way (like in tableau) is thought about in the next relase?

Thanks,

Not applicable
Author

Hi Goutham

If you looking to convert in % here you are:

1. num((YourExpression), '#,##0%')

2. Number formatting should be Number

3. Formatting should be simple and select 12% from drop down

Not applicable
Author

But for Open Rate it should be in percentage, and for delivered emails it must be in values

MVP

and for the others?
Can you share your app with just this chart on it? I'll try sthing

Not applicable
Author

Okay bro,,

Not applicable
Author

omarbensalem‌ !

I want Delivered Emails as same(Values) and Open Rate in percentage

MVP

I found out 2 "solutions"; I don't know if it's appealing enough though..
1st one:

in the same graphic, having some dimensions having sum(Sum) and others as % (but you'll have to know what's the % because I couldn't show the % sign):

Measure :

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

result:

2) you'll have to use a combined chart and thus, you can't have 2 dimensions in your chart but only ONLY hiearchic dimension :

and create 2 master measures:

Now, in your chart, use these dimension and measures :

result:

I click on open and confirm : I'll have sum(Sum) by segments of type open:

see the attached app

You can also have the information of the % for juste the Type OPEN for example:

Type to =Type& ' '&aggr( if(Type='OPEN',num((sum(Sum)/sum(total Sum))*100,'##0,00%')),Type)

Segment_Name to =Segment_Name& ' '&aggr( if(Type='OPEN',num((sum(Sum)/sum(total Sum))*100,'##0,00%')),Segment_Name,Type)

result :

Not applicable
Author

First option i can implement, but i need one more clarification,

I need both OPEN and SIGN-UP should be in percentage

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

Above formula works only for OPEN, but in the same formula can i insert SIGN-Up.

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