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

How to change the values in measure as percentage?

Hello All,

12.png

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
OmarBenSalem

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%'))

Capture.PNG

result:

Capture.PNG

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 :

Capture.PNG

and create 2 master measures:

Capture.PNG

Capture.PNG

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

result:

Capture.PNG

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

Capture.PNG

I click on Sign up, i'll have its segments by %:

Capture.PNG

see the attached app

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

change your dimensions from :

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 :

Capture.PNG

View solution in original post

13 Replies
kkkumar82
Specialist III
Specialist III

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

OmarBenSalem

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

OmarBenSalem

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

OmarBenSalem

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%'))

Capture.PNG

result:

Capture.PNG

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 :

Capture.PNG

and create 2 master measures:

Capture.PNG

Capture.PNG

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

result:

Capture.PNG

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

Capture.PNG

I click on Sign up, i'll have its segments by %:

Capture.PNG

see the attached app

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

change your dimensions from :

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 :

Capture.PNG

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'))