topic Re: How to count the length of the intervall (in diagram)? in QlikView https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146262#M375045 <HTML><HEAD></HEAD><BODY><P>Perhaps this </P><P></P><P><STRONG>Count(Interval(Len(Date#(Datefield,'DD.MM.YYYY'))<SPAN style="font-size: 13.3333px;">,'0','1'</SPAN>) FieldName)</STRONG></P></BODY></HTML> Tue, 26 Jul 2016 11:34:49 GMT Anil_Babu_Samineni 2016-07-26T11:34:49Z How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146260#M375043 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i would like to count the length of the intervall and the number of intervals in the diagramm.</P><P>(not in the script)</P><P></P><P>i have a date and a value 0 or 1 </P><P></P><P>ex</P><P>1.1.2016&nbsp; 0</P><P>2.1.2016&nbsp; 1</P><P><SPAN style="font-size: 13.3333px;">3.1.2016&nbsp; 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">4.1.2016&nbsp; 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">5.1.2016&nbsp; 0</SPAN></P><P><SPAN style="font-size: 13.3333px;">6.1.2016&nbsp; 0</SPAN></P><P><SPAN style="font-size: 13.3333px;">7.1.2016&nbsp; 1</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">8.1.2016&nbsp; 0</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">9.1.2016&nbsp; 1</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">10.1.2016&nbsp; 1</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">11.1.2016&nbsp; 0</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">12.1.2016&nbsp; 1<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">...</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">so i do have:</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">- 2 intervall of the length of 1 </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">- 1 intervall of the length of 2</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">- 1 intervall of the length of 3 </SPAN> </SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Any approch?</P><P>Many thx</P><P>Christoph</P></BODY></HTML> Tue, 26 Jul 2016 09:28:40 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146260#M375043 chrisg 2016-07-26T09:28:40Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146261#M375044 <HTML><HEAD></HEAD><BODY><P>Hi Cristoph,</P><P></P><P>Could you explain a little bit your question? Or attach an example.</P><P></P><P>Regards</P><P></P><P>Miguel del Valle</P></BODY></HTML> Tue, 26 Jul 2016 11:10:37 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146261#M375044 migueldelval 2016-07-26T11:10:37Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146262#M375045 <HTML><HEAD></HEAD><BODY><P>Perhaps this </P><P></P><P><STRONG>Count(Interval(Len(Date#(Datefield,'DD.MM.YYYY'))<SPAN style="font-size: 13.3333px;">,'0','1'</SPAN>) FieldName)</STRONG></P></BODY></HTML> Tue, 26 Jul 2016 11:34:49 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146262#M375045 Anil_Babu_Samineni 2016-07-26T11:34:49Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146263#M375046 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi Miguel,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">here we go:</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">number of intervals based on the value 1 and to count all intervals </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">but i need a solution in the diagram</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">manx thx</P><P style="font-size: 13.3333px;"></P><P style="margin-right: 4px;"></P><DIV style="margin-bottom: 8px;"> </DIV><DIV style="margin-left: 4px;"><DIV><DIV style="margin: 0 0 8px; background: whitesmoke;"><DIV><DIV dir="ltr"><P></P></DIV></DIV></DIV></DIV></DIV></BODY></HTML> Tue, 26 Jul 2016 11:42:24 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146263#M375046 chrisg 2016-07-26T11:42:24Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146264#M375047 <HTML><HEAD></HEAD><BODY><P>Like this</P><P>PFA</P></BODY></HTML> Tue, 26 Jul 2016 12:06:38 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146264#M375047 Anil_Babu_Samineni 2016-07-26T12:06:38Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146265#M375048 <HTML><HEAD></HEAD><BODY><P>Unfortunately this does not work - sorry</P></BODY></HTML> Tue, 26 Jul 2016 12:16:33 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146265#M375048 chrisg 2016-07-26T12:16:33Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146266#M375049 <HTML><HEAD></HEAD><BODY><P>I'm not sure if a pure gui solution will be possible but with some script-precalculation it might be solvable. Maybe this one within the attachment could be a starting point.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 26 Jul 2016 12:19:39 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146266#M375049 marcus_sommer 2016-07-26T12:19:39Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146267#M375050 <HTML><HEAD></HEAD><BODY><P>Many thx - that is helpfull!</P></BODY></HTML> Tue, 26 Jul 2016 12:49:35 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146267#M375050 chrisg 2016-07-26T12:49:35Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146268#M375051 <HTML><HEAD></HEAD><BODY><P>Hi, <SPAN style="font-size: 10pt; line-height: 1.5em;">You could use class as well.</SPAN></P></BODY></HTML> Wed, 27 Jul 2016 05:43:02 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146268#M375051 anagharao 2016-07-27T05:43:02Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146269#M375052 <HTML><HEAD></HEAD><BODY><P>Many thx - very nice approch</P></BODY></HTML> Wed, 27 Jul 2016 06:59:23 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146269#M375052 chrisg 2016-07-27T06:59:23Z Re: How to count the length of the intervall (in diagram)? https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146270#M375053 <HTML><HEAD></HEAD><BODY><P>Hi Markus,</P><P></P><P>i just added </P><P></P><P><EM>(previous(Value) = 0 or isNull(previous(Value) </EM></P><P></P><P>so i do not have a problem when the interval starts with the fisrt date.</P><P></P><P>/Christoph</P></BODY></HTML> Tue, 09 Aug 2016 08:54:37 GMT https://community.qlik.com/t5/QlikView/How-to-count-the-length-of-the-intervall-in-diagram/m-p/1146270#M375053 chrisg 2016-08-09T08:54:37Z