topic Table simple .. count(min(week) where week is not a dimension in QlikView https://community.qlik.com/t5/QlikView/Table-simple-count-min-week-where-week-is-not-a-dimension/m-p/599860#M546396 <HTML><HEAD></HEAD><BODY><P>good morning, </P><P>to see if you can help me,&nbsp; please</P><P>I have a set of items with a delivery date of order,&nbsp; In the script I calculate the load weekname both dates. </P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>item</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>order date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>w_od_name</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>delivery date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>w_dd_name</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">03/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">05/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">07/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">04/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">02/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">08/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">18/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/03</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">08/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">19/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/03</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">29/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/05</SPAN></TD></TR></TBODY></TABLE><P></P><P>the goal is to represent the number of different items that are delivered in the MIN w_od_name, being requested a w_dd_name as dimension. I get </P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>w_od_name</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>MinString(w_dd_name)</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>count(if(w_dd_name=MinString(total w_dd_name),item))</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"><STRONG>2014/01 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>5 </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/03</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR></TBODY></TABLE><P></P><P>I get to set the number of items for the lowest week of the document but not the dimension </P><P>please,, help me</P><P></P><P>thanks and regards</P></BODY></HTML> Thu, 20 Mar 2014 08:55:16 GMT jtrillori 2014-03-20T08:55:16Z Table simple .. count(min(week) where week is not a dimension https://community.qlik.com/t5/QlikView/Table-simple-count-min-week-where-week-is-not-a-dimension/m-p/599860#M546396 <HTML><HEAD></HEAD><BODY><P>good morning, </P><P>to see if you can help me,&nbsp; please</P><P>I have a set of items with a delivery date of order,&nbsp; In the script I calculate the load weekname both dates. </P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>item</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>order date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>w_od_name</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>delivery date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>w_dd_name</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">03/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">05/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">07/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">11/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">04/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">02/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">06/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">10/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">08/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">18/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/03</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">08/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">19/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/03</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">29/01/2014</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/05</SPAN></TD></TR></TBODY></TABLE><P></P><P>the goal is to represent the number of different items that are delivered in the MIN w_od_name, being requested a w_dd_name as dimension. I get </P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>w_od_name</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>MinString(w_dd_name)</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>count(if(w_dd_name=MinString(total w_dd_name),item))</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#f5f5f5"><TD bgcolor="#f5f5f5"></TD><TD bgcolor="#f5f5f5"><STRONG>2014/01 </STRONG></TD><TD bgcolor="#f5f5f5"><STRONG>5 </STRONG></TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/01</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/03</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2014/02</SPAN></TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">0</SPAN></TD></TR></TBODY></TABLE><P></P><P>I get to set the number of items for the lowest week of the document but not the dimension </P><P>please,, help me</P><P></P><P>thanks and regards</P></BODY></HTML> Thu, 20 Mar 2014 08:55:16 GMT https://community.qlik.com/t5/QlikView/Table-simple-count-min-week-where-week-is-not-a-dimension/m-p/599860#M546396 jtrillori 2014-03-20T08:55:16Z