topic Set analysis - One criteria and Month in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477419#M1139994 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I'm trying to set up a gauge chart where the sum if of a pre-set criteria and then linked to current month. Please can you put me right, the formula I am using is below where I want the sum to be where <STRONG>phase</STRONG> is equal to 'community' and current month.</P><P></P><P>sum({&lt;PHASE='COMMUNITY',MONTH={"$(=monthstart(today()))"} &gt;} VALUE)</P><P></P><P>With thanks,</P><P>Simon</P></BODY></HTML> Wed, 25 Sep 2013 12:57:45 GMT 2013-09-25T12:57:45Z Set analysis - One criteria and Month https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477419#M1139994 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I'm trying to set up a gauge chart where the sum if of a pre-set criteria and then linked to current month. Please can you put me right, the formula I am using is below where I want the sum to be where <STRONG>phase</STRONG> is equal to 'community' and current month.</P><P></P><P>sum({&lt;PHASE='COMMUNITY',MONTH={"$(=monthstart(today()))"} &gt;} VALUE)</P><P></P><P>With thanks,</P><P>Simon</P></BODY></HTML> Wed, 25 Sep 2013 12:57:45 GMT https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477419#M1139994 2013-09-25T12:57:45Z Re: Set analysis - One criteria and Month https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477420#M1139995 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">hello. quite good:</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum({&lt;PHASE={'COMMUNITY'},MONTH={"$(=month(today()))"} &gt;} VALUE)</SPAN></P></BODY></HTML> Wed, 25 Sep 2013 13:16:07 GMT https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477420#M1139995 2013-09-25T13:16:07Z Re: Set analysis - One criteria and Month https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477421#M1139996 <HTML><HEAD></HEAD><BODY><P>Thank you!</P></BODY></HTML> Wed, 25 Sep 2013 14:35:45 GMT https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477421#M1139996 2013-09-25T14:35:45Z Re: Set analysis - One criteria and Month https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477422#M1139997 <HTML><HEAD></HEAD><BODY><P>WAS THE correct ANSWER? PLS QLIK ON IT </P></BODY></HTML> Wed, 25 Sep 2013 14:44:22 GMT https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477422#M1139997 2013-09-25T14:44:22Z Re: Set analysis - One criteria and Month https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477423#M1139998 <HTML><HEAD></HEAD><BODY><P>All done, sorry couldn't see the button on the view I was earlier. Thank you, I'm now playing around with date fields in vFromDates so I may still break it!</P></BODY></HTML> Wed, 25 Sep 2013 14:47:09 GMT https://community.qlik.com/t5/QlikView/Set-analysis-One-criteria-and-Month/m-p/477423#M1139998 2013-09-25T14:47:09Z