Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Urgent expression?

i have bar chart

here i am mentioning single bar it self used space and non used space like

for example i have 100 md hard disk.

used space is 67.5 mb mb  and un used space is 33.5 mb  in bar chart i am showing it in single bar it self used space in one colour and  not used space in another colour

my intention i want show it in percentage manner   like

B

A

R

C  ------  used space 67.5%  (  now i have like this   67.5)

H

A

R  --- un used space   33.5    (now i have like this ( 33.5)

T

5 Replies
jyothish8807
Master II
Master II

Hi,

Use a staked chart

Create a expression:

=Used space/Total Space

=freespace/total space

in Numbers tab select the expression and select %.

Regards

KC

Best Regards,
KC
Anonymous
Not applicable
Author

i dont have field called total.

they have used option in presentation tab > sub total on below and calculating

jyothish8807
Master II
Master II

You cant get anything in % unless you dont know the total.

Can you share your sheet it will be helpful to understand.

Regards

KC

Best Regards,
KC
Anonymous
Not applicable
Author

sum(usedspace)/sum(totalspace)    and

sum(freespace)/sum(totalspace) 

is this expressions are  right?  can i use in stacked bar chart?

jyothish8807
Master II
Master II

Right looks good to me.

Then go to Number tab in you chart, select the expression

click on override document settion and tick show in percentage.

Hope it works.

Regards

KC

Best Regards,
KC