topic Calculated dimensions and Dimension limits in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimensions-and-Dimension-limits/m-p/818896#M288702 <HTML><HEAD></HEAD><BODY><P>Hi there, I am trying to display bar chart x-axis labels spanned over 2 lines and to do so I followed what <A _jive_internal="true" href="https://community.qlik.com/message/186406#186406">this reply</A> suggests, i.e. using a calculated dimension that adds a carriage return somewhere in the middle of the field that you want to use as a dimension.</P><P>The trick seems to work in terms of labels but, actually, it seems like unexpected filters get applied as you can see by comparing the following two pictures.</P><P style="text-align: center;"><IMG alt="Before.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71070_Before.png" style="width: 620px; height: 136px;" /></P><P style="text-align: center;"></P><P style="text-align: center;"><IMG alt="after.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71071_after.png" style="width: 620px; height: 136px;" /></P><P style="text-align: left;">The curious thing is that if I take the "Restrict which values are displayed using the first expression" flag off, I get close to the result I want to achieve:</P><P style="text-align: center;"><IMG alt="no dim restr.png" class="jive-image" src="/legacyfs/online/71100_no dim restr.png" style="width: 620px; height: 136px;" /></P><P style="text-align: left;">Note the scrollbar that is now shown and that I don't want to display.</P><P style="text-align: left;"></P><P style="text-align: left;">How can this be fiixed?</P></BODY></HTML> Wed, 12 Nov 2014 14:42:41 GMT googel84 2014-11-12T14:42:41Z Calculated dimensions and Dimension limits https://community.qlik.com/t5/QlikView/Calculated-dimensions-and-Dimension-limits/m-p/818896#M288702 <HTML><HEAD></HEAD><BODY><P>Hi there, I am trying to display bar chart x-axis labels spanned over 2 lines and to do so I followed what <A _jive_internal="true" href="https://community.qlik.com/message/186406#186406">this reply</A> suggests, i.e. using a calculated dimension that adds a carriage return somewhere in the middle of the field that you want to use as a dimension.</P><P>The trick seems to work in terms of labels but, actually, it seems like unexpected filters get applied as you can see by comparing the following two pictures.</P><P style="text-align: center;"><IMG alt="Before.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71070_Before.png" style="width: 620px; height: 136px;" /></P><P style="text-align: center;"></P><P style="text-align: center;"><IMG alt="after.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71071_after.png" style="width: 620px; height: 136px;" /></P><P style="text-align: left;">The curious thing is that if I take the "Restrict which values are displayed using the first expression" flag off, I get close to the result I want to achieve:</P><P style="text-align: center;"><IMG alt="no dim restr.png" class="jive-image" src="/legacyfs/online/71100_no dim restr.png" style="width: 620px; height: 136px;" /></P><P style="text-align: left;">Note the scrollbar that is now shown and that I don't want to display.</P><P style="text-align: left;"></P><P style="text-align: left;">How can this be fiixed?</P></BODY></HTML> Wed, 12 Nov 2014 14:42:41 GMT https://community.qlik.com/t5/QlikView/Calculated-dimensions-and-Dimension-limits/m-p/818896#M288702 googel84 2014-11-12T14:42:41Z Re: Calculated dimensions and Dimension limits https://community.qlik.com/t5/QlikView/Calculated-dimensions-and-Dimension-limits/m-p/818897#M288703 <HTML><HEAD></HEAD><BODY><P>I found a very simple workaround: using (when it does not make any difference) the "Largest" criterion instead of "First" in the "Dimension limits" tab of the chart proterties.</P><P>I don't know why "First" was causing the problem but it was!</P></BODY></HTML> Thu, 13 Nov 2014 13:27:25 GMT https://community.qlik.com/t5/QlikView/Calculated-dimensions-and-Dimension-limits/m-p/818897#M288703 googel84 2014-11-13T13:27:25Z