topic Re: Unable to View all the Years In BarChart in QlikView https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415687#M569722 <HTML><HEAD></HEAD><BODY><P>Thanks Ramsamy,I got it, I have posted sample date range file ,please check it and reply me</P><P></P><P>Regards</P><P>Rams</P></BODY></HTML> Tue, 18 Sep 2012 16:48:54 GMT 2012-09-18T16:48:54Z Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415683#M569718 <HTML><HEAD></HEAD><BODY><P>Hi community members,</P><P></P><P>I have created a barchart with Year field as dimension and&nbsp; sales as expression, but the dimesnion is showing only two values, actually I am having a total 8 values in the field,anyone of you help me out</P><P></P><P>Regards</P><P>rams</P></BODY></HTML> Mon, 17 Sep 2012 23:05:45 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415683#M569718 2012-09-17T23:05:45Z Re: Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415684#M569719 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Do you have any sales data associated with the other 6 years that are not displayed?</P><P>If not, they will by default be suppressed from the rendered chart but this can be changed under the Properties &gt; Presentation &gt; Suppress zero values</P></BODY></HTML> Tue, 18 Sep 2012 01:46:41 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415684#M569719 Anonymous 2012-09-18T01:46:41Z Re: Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415685#M569720 <HTML><HEAD></HEAD><BODY><P>I have unchecked the supress zero values, still I am unable to see all the years</P></BODY></HTML> Tue, 18 Sep 2012 16:15:54 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415685#M569720 2012-09-18T16:15:54Z Re: Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415686#M569721 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> I didn't check the mail, sorry for that. For this, use like this,</P><P></P><P>Year as Dimension</P><P>If(Sum(Sales) &gt; 0, Sum(Sales), 0) as Expression</P><P></P><P>if you didn't get means,select show all values in dimension tab..</P><P></P><P>From this, you can get the requirement..</P></BODY></HTML> Tue, 18 Sep 2012 16:27:08 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415686#M569721 MayilVahanan 2012-09-18T16:27:08Z Re: Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415687#M569722 <HTML><HEAD></HEAD><BODY><P>Thanks Ramsamy,I got it, I have posted sample date range file ,please check it and reply me</P><P></P><P>Regards</P><P>Rams</P></BODY></HTML> Tue, 18 Sep 2012 16:48:54 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415687#M569722 2012-09-18T16:48:54Z Re: Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415688#M569723 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Can you provide as correct or helpful answer if you got the requirement means, that helps other to find the solution for the related answer</P></BODY></HTML> Tue, 18 Sep 2012 17:37:19 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415688#M569723 MayilVahanan 2012-09-18T17:37:19Z Re: Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415689#M569724 <HTML><HEAD></HEAD><BODY><P>I am unable to get the data related to other years,eventhough their is data related to that years, can you tell me where is the problem</P></BODY></HTML> Tue, 18 Sep 2012 18:04:34 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415689#M569724 2012-09-18T18:04:34Z Re: Unable to View all the Years In BarChart https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415690#M569725 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P> Use tablebox and choose the field as you want and check whether there is the data or not for that years. or </P><P>simple see in the table viewer..</P><P></P><P>Hope that helps</P></BODY></HTML> Tue, 18 Sep 2012 18:06:44 GMT https://community.qlik.com/t5/QlikView/Unable-to-View-all-the-Years-In-BarChart/m-p/415690#M569725 MayilVahanan 2012-09-18T18:06:44Z