Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Percentage in Block Chart

Hello,

I have this block chart, and I have a section called OTHERS, well, in each section different from others I have my percentage. But the OTHERS section gives me a decimal number. How can I make that OTHERS section percentage?

I attach two images that could be helpful.

Block Chart.png

expression.png

5 Replies
Sokkorn
Master
Master

Hi,

Let try this expression: NUM(COUNT(DISTINCT {<>} ID) / COUNT(DISTINCT {<>} TOTAL ID),'###.00%')

Regards,

Sokkorn Cheav

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try by check the Relative option in the expression tab.

check with the attached image.

Anonymous
Not applicable
Author

Hello,

as ID do you mean Id_autorizacion?

and what should I insert between the {<>} marks?

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try the following expression

=NUM(COUNT(DISTINCT ID) / COUNT(DISTINCT TOTAL ID),'###.00%')

Regards,

Jagan.

Anonymous
Not applicable
Author

Hello, I've done that, but the group OTHERS keep showing as a decimal number, it doesn't matter if I check Relative Option.

The other values are showing as percentage. All I want to know is what percentage correspond to OTHERS group.


Look what I got OTHERS = Otros (the aggrupation that QV make with a bunch of data), that's the one I don't understand the problem with the percentage.

Otros.png

normal.png