topic Re: how to create a chart by considering three dimensions in QlikView https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494961#M1142595 <HTML><HEAD></HEAD><BODY><P>Can you post a qvw with a sample of your data?</P></BODY></HTML> Fri, 06 Sep 2013 16:17:10 GMT Clever_Anjos 2013-09-06T16:17:10Z how to create a chart by considering three dimensions https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494960#M1142594 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to create&nbsp; chart by considering three dimensions. This is my requirement:</P><P></P><P>Hi,</P><P></P><P>I need to create a Bar chart by Team member and error type. showing week1, week2, week3, week4 and so on on X axis and percentage of failures on Y axis. But this all should by considering Team member and error type.</P><P></P><P>For more clarification I am adding the expression</P><P></P><P>&nbsp; </P><P>Sum</P><P><BR />({&lt;Result={'Fail'}&gt;} distinct Reference)/Sum(Distinct(Reference)) </P><P></P><P>And I need to use the calculated dimensions as </P><P>&nbsp; </P><P>=</P><P>IF(FiscalWeekSerial&gt;=$(curFiscalWeekSeq)-4,</P><P>FiscalWeek)</P><P></P><P></P><P>and how can I add columns Team Member and Error types? Could anyone help me</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 06 Sep 2013 15:52:50 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494960#M1142594 2013-09-06T15:52:50Z Re: how to create a chart by considering three dimensions https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494961#M1142595 <HTML><HEAD></HEAD><BODY><P>Can you post a qvw with a sample of your data?</P></BODY></HTML> Fri, 06 Sep 2013 16:17:10 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494961#M1142595 Clever_Anjos 2013-09-06T16:17:10Z Re: how to create a chart by considering three dimensions https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494962#M1142596 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please have a look on the attached and help me.</P></BODY></HTML> Fri, 06 Sep 2013 16:34:58 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494962#M1142596 2013-09-06T16:34:58Z Re: how to create a chart by considering three dimensions https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494963#M1142597 <HTML><HEAD></HEAD><BODY><P>Well...</P><P>Your qvw seems empty to me</P></BODY></HTML> Fri, 06 Sep 2013 16:40:11 GMT https://community.qlik.com/t5/QlikView/how-to-create-a-chart-by-considering-three-dimensions/m-p/494963#M1142597 Clever_Anjos 2013-09-06T16:40:11Z