topic How to do expressions for set analysis depends on parameters? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-expressions-for-set-analysis-depends-on-parameters/m-p/460657#M1304700 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need help guys, I got problems in creating set analysis for the following:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="252" style="width: 338px; border: 1px solid #000000; height: 253px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>DATE</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>ITEM</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>AMOUNT</STRONG><BR /></TH></TR><TR><TD>11/20/2012</TD><TD>HTC</TD><TD>25555</TD></TR><TR><TD>11/22/2012</TD><TD>SAMSUNG</TD><TD>26800</TD></TR><TR><TD>11/24/2012</TD><TD>IPHONE4S</TD><TD>35400</TD></TR><TR><TD>11/30/2012</TD><TD>IPHONE4S</TD><TD>34758</TD></TR><TR><TD>12/15/2012</TD><TD>SAMSUNG</TD><TD>24390</TD></TR><TR><TD>12/20/2012</TD><TD>HTC</TD><TD>25525</TD></TR><TR><TD>12/25/2012</TD><TD>IPHONE5</TD><TD>49899</TD></TR><TR><TD>12/30/2012</TD><TD>HTC</TD><TD>25500</TD></TR><TR><TD>1/2/2013</TD><TD>HTC</TD><TD>30200</TD></TR><TR><TD>1/4/2013</TD><TD>SAMSUNG</TD><TD>28930</TD></TR><TR><TD>1/5/2013</TD><TD>HTC</TD><TD>12360</TD></TR><TR><TD>1/9/2013</TD><TD>IPHONE4S</TD><TD>34500</TD></TR><TR><TD>1/20/2013</TD><TD>SAMSUNG</TD><TD>24333</TD></TR><TR><TD>1/23/2013</TD><TD>IPHONE4S</TD><TD>32330</TD></TR></TBODY></TABLE><P></P><P>SET ANALYSIS FOR EACH ITEMS (TOTAL SALES)</P><P></P><P>1) This Year</P><P>2) Last Year</P><P>3) Year-to-date</P><P>4) Last-Year-to-date</P><P>5) This Month</P><P>6) Last Month</P><P></P><P>Thanks,</P><P>Bill</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z How to do expressions for set analysis depends on parameters? https://community.qlik.com/t5/QlikView/How-to-do-expressions-for-set-analysis-depends-on-parameters/m-p/460657#M1304700 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need help guys, I got problems in creating set analysis for the following:</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="252" style="width: 338px; border: 1px solid #000000; height: 253px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>DATE</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>ITEM</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>AMOUNT</STRONG><BR /></TH></TR><TR><TD>11/20/2012</TD><TD>HTC</TD><TD>25555</TD></TR><TR><TD>11/22/2012</TD><TD>SAMSUNG</TD><TD>26800</TD></TR><TR><TD>11/24/2012</TD><TD>IPHONE4S</TD><TD>35400</TD></TR><TR><TD>11/30/2012</TD><TD>IPHONE4S</TD><TD>34758</TD></TR><TR><TD>12/15/2012</TD><TD>SAMSUNG</TD><TD>24390</TD></TR><TR><TD>12/20/2012</TD><TD>HTC</TD><TD>25525</TD></TR><TR><TD>12/25/2012</TD><TD>IPHONE5</TD><TD>49899</TD></TR><TR><TD>12/30/2012</TD><TD>HTC</TD><TD>25500</TD></TR><TR><TD>1/2/2013</TD><TD>HTC</TD><TD>30200</TD></TR><TR><TD>1/4/2013</TD><TD>SAMSUNG</TD><TD>28930</TD></TR><TR><TD>1/5/2013</TD><TD>HTC</TD><TD>12360</TD></TR><TR><TD>1/9/2013</TD><TD>IPHONE4S</TD><TD>34500</TD></TR><TR><TD>1/20/2013</TD><TD>SAMSUNG</TD><TD>24333</TD></TR><TR><TD>1/23/2013</TD><TD>IPHONE4S</TD><TD>32330</TD></TR></TBODY></TABLE><P></P><P>SET ANALYSIS FOR EACH ITEMS (TOTAL SALES)</P><P></P><P>1) This Year</P><P>2) Last Year</P><P>3) Year-to-date</P><P>4) Last-Year-to-date</P><P>5) This Month</P><P>6) Last Month</P><P></P><P>Thanks,</P><P>Bill</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/How-to-do-expressions-for-set-analysis-depends-on-parameters/m-p/460657#M1304700 2026-01-26T18:19:17Z