topic Turning Chart values into % in QlikView

Turning Chart values into %

Mon, 14 May 2012 14:06:08 GMT

Hello,

I'm trying to convert my values seen below in the image into percent. Of course this should be simple yet its not working for me. Below you can see the expression format i am using to convert to %. Any thoughts or ideas?

If you need more information, I can provide.

Thank you in advance.

Turning Chart values into %

Jason_Michaelides — Mon, 14 May 2012 14:15:44 GMT

Percent of what? Your expression should evaluate to a value between 0 and 1 for this to work, I think.

Turning Chart values into %

Mon, 14 May 2012 14:36:30 GMT

Thanks Jason for getting back to me.

I'm a newbe to developing so not sure if the item below is what you are asking me. I have setup different expressions for this chart to work. So, i'm defining the percent format for the top 3 expressions.

Project: [Project Hours]/[Total Hours]
Operational: [Operational Support Hours]/[Total Hours]
Administrative: [Administrative Hours]/[Total Hours]

Total Hours: =[Administrative Hours]+[Operational Support Hours]+[Project Hours]

Administrative Hours: sum({<[Project Work Level 2]={'Administrative'}>}[Allocated Hours])

Operational Hours: sum({<[Project Work Level 2]={'Operational Support'}>}[Allocated Hours])

Project Hours: sum({<[Project Work Level 2]={'Project'}>}[Allocated Hours])

Turning Chart values into %

Jason_Michaelides — Mon, 14 May 2012 15:28:55 GMT

Can you post your app?

Turning Chart values into %

Mon, 14 May 2012 16:04:35 GMT

Sorry, this may be a dumb question, but what do you mean "post your app"? If you mean what application we use qlikview for - then its Clarity PPM.

Turning Chart values into %

Jason_Michaelides — Mon, 14 May 2012 16:27:53 GMT

Sorry - I mean can you attach your QVW file to the thread so we can have a look for you? Is normally much easier than eeking out details one at a time!

Turning Chart values into %

Mon, 14 May 2012 16:32:44 GMT

On the numbers tab of the chart you can select the expression and click on Show as Percentage.

Stephen

Turning Chart values into %

Mon, 14 May 2012 16:40:09 GMT

@Jason - Unfotunately i don't know an easy way to get to that file. Although the server is hosted within my company, our application is hosted by Axis and i access it via the web. So i've been doing my dev work in the myview tab.

But if there is a way to get it and you have the patience to give instructions, i can certainly try.

@sjcharles - isn't that where i am doing the formatting in my screenshot above?

Turning Chart values into %

Jason_Michaelides — Mon, 14 May 2012 16:41:54 GMT

Oh - no idea, sorry.

Turning Chart values into %

Mon, 14 May 2012 16:57:06 GMT

This is were I am looking.

Stephen

Turning Chart values into %

Tue, 15 May 2012 17:49:59 GMT

Tried to change it to number format and i get a wierd value for administrative hours...