topic Re: Change if statements into set analysis in QlikView https://community.qlik.com/t5/QlikView/Change-if-statements-into-set-analysis/m-p/1054496#M353588 <HTML><HEAD></HEAD><BODY><P>Do you have a sample where we can play around with this?</P></BODY></HTML> Thu, 18 Feb 2016 17:57:55 GMT sunny_talwar 2016-02-18T17:57:55Z Change if statements into set analysis https://community.qlik.com/t5/QlikView/Change-if-statements-into-set-analysis/m-p/1054495#M353587 <HTML><HEAD></HEAD><BODY><P>‌</P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #000000;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: #1f497d;">I am trying (and failing) to change </SPAN><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: #1f497d;">this </SPAN><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: #1f497d;">expression</SPAN><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: #1f497d;"> </SPAN><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: #1f497d;">into set analysis. Can anyone help? </SPAN></P><P></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #000000;"><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">addmonths</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">makedate</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(2015,1,1),</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">max</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">i</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">))&lt;</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">today</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(),</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #000000;"><SPAN style="font-size: 9pt; font-family: 'Courier New';"><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">rangesum</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">( </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Above</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Sum</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">((</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">month</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Closed Date]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">)+</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">year</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Closed Date]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">)*12)-</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">year</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Loss Date]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">)*12=</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">i</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">and</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Loss Year]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">=2015,</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">Status</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">='Closed',</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">TPI_Inc</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">))), 0, </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">rowno</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">() ))</SPAN></SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #000000;"><SPAN style="font-size: 9pt; font-family: 'Courier New';"><BR />/<SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">rangesum</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">( </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Above</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">count</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">Distinct</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">((</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">month</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Closed Date]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">)+</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">year</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Closed Date]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">)*12)-</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">year</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Loss Date]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">)*12=</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">i</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">and</SPAN> <SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[Loss Year]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">=2015,</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">if</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">Status</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">='Closed',</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: maroon;">[MJCNFH Application ID]</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">)))), 0, </SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">rowno</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">() ))<BR /><BR /><BR />,</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New'; color: blue;">null</SPAN><SPAN style="font-size: 9pt; font-family: 'Courier New';">())</SPAN></SPAN></P><P></P><P>Thanks</P></BODY></HTML> Wed, 17 Feb 2016 15:06:20 GMT https://community.qlik.com/t5/QlikView/Change-if-statements-into-set-analysis/m-p/1054495#M353587 2016-02-17T15:06:20Z Re: Change if statements into set analysis https://community.qlik.com/t5/QlikView/Change-if-statements-into-set-analysis/m-p/1054496#M353588 <HTML><HEAD></HEAD><BODY><P>Do you have a sample where we can play around with this?</P></BODY></HTML> Thu, 18 Feb 2016 17:57:55 GMT https://community.qlik.com/t5/QlikView/Change-if-statements-into-set-analysis/m-p/1054496#M353588 sunny_talwar 2016-02-18T17:57:55Z