topic Re: Error in chart in QlikView https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697517#M671528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Its my bad It is like</P><P></P><P><STRONG>if(wildmatch(Amount_Type,'B'),Amount_Type)</STRONG></P><P></P><P>Regards</P></BODY></HTML> Mon, 15 Sep 2014 12:17:30 GMT PrashantSangle 2014-09-15T12:17:30Z Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697509#M671520 <HTML><HEAD></HEAD><BODY><P><BR />Hi friends</P><P></P><P>I have data like this</P><P></P><P> Amount_Type Amount</P><P> A 800</P><P>B 800</P><P>B 800</P><P>B 900</P><P>C 800</P><P></P><P>I added caluculated Dimention like Amount_Type ='B' and Expression as Sum(Amount).</P><P>I am getting only -1 and 0 as Dimentions.</P><P></P><P>Thanks</P><P>Pavan</P></BODY></HTML> Mon, 15 Sep 2014 11:36:08 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697509#M671520 2014-09-15T11:36:08Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697510#M671521 <HTML><HEAD></HEAD><BODY><P>I think the above function is giving you the result in boolean format </P></BODY></HTML> Mon, 15 Sep 2014 11:43:44 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697510#M671521 2014-09-15T11:43:44Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697511#M671522 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi Pavan,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Try like this in calculated dimension and check the suppress when value is null option</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">=if<STRONG>(Amount_Type = 'B', Amount_Type)</STRONG></SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Manideep</SPAN></P></BODY></HTML> Mon, 15 Sep 2014 11:44:59 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697511#M671522 manideep78 2014-09-15T11:44:59Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697512#M671523 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: calibri, verdana, arial, sans-serif;">=if</SPAN><STRONG style="font-family: calibri, verdana, arial, sans-serif; color: #3d3d3d;">(Amount_Type = 'B', Amount_Type)</STRONG></P></BODY></HTML> Mon, 15 Sep 2014 11:47:17 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697512#M671523 sujeetsingh 2014-09-15T11:47:17Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697513#M671524 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Write</P><P><STRONG>wildmatch(Amount_Type,'B',Amount_Type) </STRONG>use this as your calculated Dimension.</P><P></P><P>And select Supress Null values in Dimension tab</P><P></P><P>Regards</P></BODY></HTML> Mon, 15 Sep 2014 11:47:30 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697513#M671524 PrashantSangle 2014-09-15T11:47:30Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697514#M671525 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>have a look at attached application.</P><P>two approaches shown.</P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 15 Sep 2014 11:56:22 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697514#M671525 ashfaq_haseeb 2014-09-15T11:56:22Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697515#M671526 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table</P><P></P><P>Dimension = Calculated Dimension</P><P>=Aggr(IF(Amount_Type = 'B',Amount_Type),Amount_Type)</P><P>Tick Suppress When Value is NULL</P><P></P><P>Expression</P><P>SUM(Amount)</P></BODY></HTML> Mon, 15 Sep 2014 11:56:28 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697515#M671526 MK_QSL 2014-09-15T11:56:28Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697516#M671527 <HTML><HEAD></HEAD><BODY><P>again its showing 1 and 2 values</P></BODY></HTML> Mon, 15 Sep 2014 12:11:02 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697516#M671527 2014-09-15T12:11:02Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697517#M671528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Its my bad It is like</P><P></P><P><STRONG>if(wildmatch(Amount_Type,'B'),Amount_Type)</STRONG></P><P></P><P>Regards</P></BODY></HTML> Mon, 15 Sep 2014 12:17:30 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697517#M671528 PrashantSangle 2014-09-15T12:17:30Z Re: Error in chart https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697518#M671529 <HTML><HEAD></HEAD><BODY><P>have you checked my reply?</P></BODY></HTML> Mon, 15 Sep 2014 12:50:06 GMT https://community.qlik.com/t5/QlikView/Error-in-chart/m-p/697518#M671529 MK_QSL 2014-09-15T12:50:06Z