topic Free Text Straight Chart in QlikView https://community.qlik.com/t5/QlikView/Free-Text-Straight-Chart/m-p/473261#M483819 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to create a Straight Chart that the Dimensions are free Text and the expresssion is calculated as such </P><P><STRONG>=count(distinct if(time(update_time_JD_1,'hh,mm,ss') &gt; time('00:00:00','hh,mm,ss') AND time(update_time_JD_1,'hh,mm,ss') &lt; time('29:59:59','hh,mm,ss'), update_time_JD_1))</STRONG></P><P></P><P>E.G.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="68" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 452px; HEIGHT: 64px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Free Text (Dimension)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Expression</STRONG></SPAN></TH></TR><TR><TD>Last Updated 3 Days ago</TD><TD>121</TD></TR><TR><TD><P>Last Updated more than 3 Days Ago</P></TD><TD><P>30</P></TD></TR><TR><TD>Last Updated more than 5 Days Ago</TD><TD>32</TD></TR><TR><TD><P>Last Updated more than 10 Days Ago</P></TD><TD>40</TD></TR><TR><TD>Last Updated more than 14 Days Ago</TD><TD>5</TD></TR><TR><TD>Last Updated more than 20+ Days ago</TD><TD>16</TD></TR></TBODY></TABLE><P></P><P>The above table is how I want the chart to look, with the Free Text being what I want to enter and the expression being above, obvisouly with changes made to the expression.</P><P></P><P>Regards,</P><P></P><P>Jon Ditchfield</P></BODY></HTML> Fri, 14 Jun 2013 10:30:47 GMT 2013-06-14T10:30:47Z Free Text Straight Chart https://community.qlik.com/t5/QlikView/Free-Text-Straight-Chart/m-p/473261#M483819 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to create a Straight Chart that the Dimensions are free Text and the expresssion is calculated as such </P><P><STRONG>=count(distinct if(time(update_time_JD_1,'hh,mm,ss') &gt; time('00:00:00','hh,mm,ss') AND time(update_time_JD_1,'hh,mm,ss') &lt; time('29:59:59','hh,mm,ss'), update_time_JD_1))</STRONG></P><P></P><P>E.G.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="68" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 452px; HEIGHT: 64px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Free Text (Dimension)</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Expression</STRONG></SPAN></TH></TR><TR><TD>Last Updated 3 Days ago</TD><TD>121</TD></TR><TR><TD><P>Last Updated more than 3 Days Ago</P></TD><TD><P>30</P></TD></TR><TR><TD>Last Updated more than 5 Days Ago</TD><TD>32</TD></TR><TR><TD><P>Last Updated more than 10 Days Ago</P></TD><TD>40</TD></TR><TR><TD>Last Updated more than 14 Days Ago</TD><TD>5</TD></TR><TR><TD>Last Updated more than 20+ Days ago</TD><TD>16</TD></TR></TBODY></TABLE><P></P><P>The above table is how I want the chart to look, with the Free Text being what I want to enter and the expression being above, obvisouly with changes made to the expression.</P><P></P><P>Regards,</P><P></P><P>Jon Ditchfield</P></BODY></HTML> Fri, 14 Jun 2013 10:30:47 GMT https://community.qlik.com/t5/QlikView/Free-Text-Straight-Chart/m-p/473261#M483819 2013-06-14T10:30:47Z