topic Re: percentage on top in QlikView

percentage on top

Thu, 27 Nov 2014 07:48:53 GMT

Hi,

I have created one view, but new requirement come to show percentage on top.

Ex: for remaining effort, show percentage on top and percentage will be calculated = No in Green /(No in Green ) + (No in Red)

I have attached the qvw and excel for reference.

Thanks

Re: percentage on top

Thu, 27 Nov 2014 07:55:03 GMT

attaching excel also

Re: percentage on top

sujeetsingh — Thu, 27 Nov 2014 08:12:43 GMT

Not possible in simple ways

Re: percentage on top

Thu, 27 Nov 2014 08:27:35 GMT

Hi,

Please let me know if it is possible

Thanks

Re: percentage on top

simenkg — Thu, 27 Nov 2014 08:48:42 GMT

Like this?

Re: percentage on top

Thu, 27 Nov 2014 08:51:22 GMT

Hi Simen,

Exactle same.

Thanks a lot.

Re: percentage on top

simenkg — Thu, 27 Nov 2014 08:57:01 GMT

No problem. Mark the answer as correct so the thread is closed.

Re: percentage on top

Thu, 27 Nov 2014 10:55:58 GMT

Hi Simen,

Value is not showing when it is 0%.

What can be done for that.

Re: percentage on top

simenkg — Thu, 27 Nov 2014 11:05:45 GMT

On the presentation tab, uncheck the "Supress zero-values" checkbox.

Re: percentage on top

Thu, 27 Nov 2014 13:17:45 GMT

That does not help

Re: percentage on top

Thu, 27 Nov 2014 14:02:58 GMT

Hi Simen

Can we do the first change without change in dimension and expression.

Re: percentage on top

simenkg — Thu, 27 Nov 2014 14:15:12 GMT

I don't think we can and you really should not.

Calcluated dimensions are terrible for performance and should only be used as a last resort. Set analysis is the right way to do calculations like this.

In stead of refering to the two expressions by name : [Pass] / ([Pass]+[Fail]) you can insert the expressions instead.

Re: percentage on top

Thu, 27 Nov 2014 15:10:25 GMT