topic Re: Status changes in QlikView https://community.qlik.com/t5/QlikView/Status-changes/m-p/462517#M562273 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">here</A></P></BODY></HTML> Thu, 21 Mar 2013 10:47:19 GMT Gysbert_Wassenaar 2013-03-21T10:47:19Z Status changes https://community.qlik.com/t5/QlikView/Status-changes/m-p/462516#M562272 <HTML><HEAD></HEAD><BODY><P>I have a handful of records:</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">ID</TH><TH align="center" style="background-color: #6690bc;" valign="middle">Status</TH><TH align="center" style="background-color: #6690bc;" valign="middle">StatusDate</TH><TH align="center" style="background-color: #6690bc;" valign="middle">Count</TH></TR><TR><TD>1</TD><TD>Open</TD><TD>1/1/13</TD><TD>1</TD></TR><TR><TD>1</TD><TD>Closed</TD><TD>1/15/13</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Open</TD><TD>1/10/13</TD><TD>1</TD></TR><TR><TD>2</TD><TD>Closed</TD><TD>1/30/13</TD><TD>1</TD></TR></TBODY></TABLE><P></P><P>I want to make a barchart that will show every day of the year on the X axis (using a master calendar tied to StatusDate), with a sum of Open records on the Y axis (EVERY DAY).</P><P></P><P>The above data should show:</P><P> 1 from 1/1/13 through 1/9/13</P><P>2 from 1/10/13 through 1/14/13</P><P>1 from 1/15/13 through 1/29/13</P><P></P><P>Is it possible to do this with just the data above, or do I need to make a new record for every single day of the year, per ID (lots and lots more data)?</P><P></P><P>Thank you</P></BODY></HTML> Wed, 20 Mar 2013 20:29:25 GMT https://community.qlik.com/t5/QlikView/Status-changes/m-p/462516#M562272 2013-03-20T20:29:25Z Re: Status changes https://community.qlik.com/t5/QlikView/Status-changes/m-p/462517#M562273 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field">here</A></P></BODY></HTML> Thu, 21 Mar 2013 10:47:19 GMT https://community.qlik.com/t5/QlikView/Status-changes/m-p/462517#M562273 Gysbert_Wassenaar 2013-03-21T10:47:19Z