topic Re: How to select chart item in QlikView

How to select chart item

Fri, 15 Nov 2013 15:23:06 GMT

Hi,

I have to show % of Failures by Type Vs Employee.

Could anyone help me which chart item suits this to show in graphiacal view as my user wants to see the % of Failures even though if it contains Zero values in Type and Employee

Thanks.

Re: How to select chart item

Fri, 15 Nov 2013 15:26:05 GMT

Amelia

take the pie chart

Use Emp as Dim and Type as Expr and click the expression as relative.

Show all dim and values (presentation tab)

best regards

Chris

Re: How to select chart item

Fri, 15 Nov 2013 15:31:24 GMT

Thanks

and I have to show % of Failures for Type and Employee by using below expression

Sum({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference))

when I am using Emp as Dim and Type as expr it is showing No Data to Display.

Please help me how to sort this.

Re: How to select chart item

Fri, 15 Nov 2013 15:33:37 GMT

Amelia

would you mind to share your qvw?

chris

Re: How to select chart item

Fri, 15 Nov 2013 15:38:11 GMT

Please find attched.

Re: How to select chart item

Fri, 15 Nov 2013 15:42:56 GMT

Amelia

I don't understand the problem

I did some selections or no selection and i have always results

if you want to add % on the graph click in Presentation tab, Display values

chris

Re: Re: How to select chart item

Fri, 15 Nov 2013 15:50:23 GMT

Hi Amelia,

Please consider the attachment.

Re: How to select chart item

Fri, 15 Nov 2013 15:56:29 GMT

Hi,

Thanks and just for clarity I haven't found anything different in attachment you mean is it correct?

Re: How to select chart item

Fri, 15 Nov 2013 16:14:59 GMT

Hi,

Thanks and I would like to show % of Failures for both administrator and Type. Please help how can I set this.

Re: How to select chart item

Fri, 15 Nov 2013 16:36:53 GMT

Hi,

Thanks and it is showing only Administrator but I need both Administrator and Type. Please help as I am not getting how to set this.

Re: How to select chart item

jerem1234 — Fri, 15 Nov 2013 17:36:15 GMT

What do you mean by both Administrator and Type?

Maybe create a cyclic group(or drill down group) with administrator and Type and add that as dimension?

Maybe have 2 dimensions Administrator, then Type? - this way can be overwhelming on the eyes

Maybe create an entire new Pie chart with Type as Dimension?

Not sure what you are looking for.

Re: Re: How to select chart item

Fri, 15 Nov 2013 21:19:48 GMT

Please Consider the attachment.

otherwise please more explain about "type".

Regards,