topic Re: Urgent expression? in QlikView

Urgent expression?

Anonymous — Mon, 06 Oct 2014 10:58:55 GMT

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

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

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

Re: Urgent expression?

jyothish8807 — Mon, 06 Oct 2014 11:07:15 GMT

Hi,

Use a staked chart

Create a expression:

=Used space/Total Space

=freespace/total space

in Numbers tab select the expression and select %.

Regards

Re: Urgent expression?

Anonymous — Mon, 06 Oct 2014 11:10:49 GMT

i dont have field called total.

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

Re: Urgent expression?

jyothish8807 — Mon, 06 Oct 2014 11:14:29 GMT

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

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

Regards

Re: Urgent expression?

Anonymous — Mon, 06 Oct 2014 11:23:31 GMT

sum(usedspace)/sum(totalspace) and

sum(freespace)/sum(totalspace)

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

Re: Urgent expression?

jyothish8807 — Mon, 06 Oct 2014 11:43:11 GMT

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