topic Re: chart help in QlikView https://community.qlik.com/t5/QlikView/chart-help/m-p/72344#M607520 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>And how would you write expression that counts how many times Student access system on that date. </P></BODY></HTML> Fri, 06 Apr 2018 17:44:29 GMT userid128223 2018-04-06T17:44:29Z chart help https://community.qlik.com/t5/QlikView/chart-help/m-p/72342#M607518 <HTML><HEAD></HEAD><BODY><P>so i have following field</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>StudentID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">DateStamp</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>TimeStamp</STRONG></TH></TR><TR><TD style="padding: 2px;">Eric</TD><TD style="padding: 2px;">3/22/2018</TD><TD style="padding: 2px;"><TABLE border="1" class="jiveBorder" height="50" style="border: 1px solid #000000; width: 411px; height: 41px;" width="409"><TBODY><TR><TD style="padding: 2px;">3/22/2018 3:01PM</TD></TR></TBODY></TABLE></TD></TR><TR><TD style="padding: 2px;">Eric</TD><TD style="padding: 2px;">3/22/2018</TD><TD style="padding: 2px;">3/22/2018 5:04 PM</TD></TR><TR><TD style="padding: 2px;">Eric</TD><TD style="padding: 2px;">3/22/2018</TD><TD style="padding: 2px;">3/22/2018 9:05 PM</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">3/5/2018</TD><TD style="padding: 2px;">3/5/2018 8:05 AM</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">3/5/2018</TD><TD style="padding: 2px;">3/5/2018 2:00 PM</TD></TR><TR><TD style="padding: 2px;">Paul</TD><TD style="padding: 2px;">3//5/2018</TD><TD style="padding: 2px;">3/5/2018 6:06 PM</TD></TR></TBODY></TABLE><P></P><P>Combo chart:</P><P>dimension: StudentID &amp; DateStamp</P><P>expression: count(TimeStamp) </P><P></P><P></P><P>My issue is that my date fields is not distinct and its not charting properly. How can i make dimension to only show distinct DateStamp</P></BODY></HTML> Fri, 06 Apr 2018 16:33:33 GMT https://community.qlik.com/t5/QlikView/chart-help/m-p/72342#M607518 userid128223 2018-04-06T16:33:33Z Re: chart help https://community.qlik.com/t5/QlikView/chart-help/m-p/72343#M607519 <HTML><HEAD></HEAD><BODY><P>You can resolve this in script or use a calculated dimension</P><P></P><P>Script</P><P><STRONG>Date(Floor(DateStamp)) as DateStamp</STRONG></P><P></P><P>CalculatedDimension</P><P><STRONG>Date(Floor(DateStamp))</STRONG></P></BODY></HTML> Fri, 06 Apr 2018 16:35:40 GMT https://community.qlik.com/t5/QlikView/chart-help/m-p/72343#M607519 sunny_talwar 2018-04-06T16:35:40Z Re: chart help https://community.qlik.com/t5/QlikView/chart-help/m-p/72344#M607520 <HTML><HEAD></HEAD><BODY><P>Thanks</P><P></P><P>And how would you write expression that counts how many times Student access system on that date. </P></BODY></HTML> Fri, 06 Apr 2018 17:44:29 GMT https://community.qlik.com/t5/QlikView/chart-help/m-p/72344#M607520 userid128223 2018-04-06T17:44:29Z Re: chart help https://community.qlik.com/t5/QlikView/chart-help/m-p/72345#M607521 <HTML><HEAD></HEAD><BODY><P>it shows total count, instead of per date total. </P></BODY></HTML> Fri, 06 Apr 2018 17:45:15 GMT https://community.qlik.com/t5/QlikView/chart-help/m-p/72345#M607521 userid128223 2018-04-06T17:45:15Z Re: chart help https://community.qlik.com/t5/QlikView/chart-help/m-p/72346#M607522 <HTML><HEAD></HEAD><BODY><P>Not sure what you mean? For the sample, what is the expected output?</P></BODY></HTML> Fri, 06 Apr 2018 17:46:32 GMT https://community.qlik.com/t5/QlikView/chart-help/m-p/72346#M607522 sunny_talwar 2018-04-06T17:46:32Z