topic Re: Set Analysis - Fail to show the benchmark value in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Fail-to-show-the-benchmark-value/m-p/1172649#M911179 <HTML><HEAD></HEAD><BODY><P>Try </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(<STRONG>TOTAL&lt;DAY&gt;</STRONG> {$&lt;ID={4}&gt;}MONEY)</SPAN></P></BODY></HTML> Sun, 12 Jun 2016 11:32:18 GMT swuehl 2016-06-12T11:32:18Z Set Analysis - Fail to show the benchmark value https://community.qlik.com/t5/QlikView/Set-Analysis-Fail-to-show-the-benchmark-value/m-p/1172648#M911178 <HTML><HEAD></HEAD><BODY><P>I have a Table:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 216px;"><TBODY><TR><TD height="21" width="72">ID</TD><TD width="72">DAY</TD><TD width="72">MONEY</TD></TR><TR><TD align="right" height="21">1</TD><TD>MON</TD><TD align="right">1</TD></TR><TR><TD align="right" height="21">1</TD><TD>TUE</TD><TD align="right">2</TD></TR><TR><TD align="right" height="21">2</TD><TD>MON</TD><TD align="right">3</TD></TR><TR><TD align="right" height="21">2</TD><TD>TUE</TD><TD align="right">4</TD></TR><TR><TD align="right" height="21">3</TD><TD>MON</TD><TD align="right">5</TD></TR><TR><TD align="right" height="21">3</TD><TD>TUE</TD><TD align="right">6</TD></TR><TR><TD align="right" height="21">Benchmark</TD><TD>MON</TD><TD align="right">7</TD></TR><TR><TD align="right" height="21">Benchmark</TD><TD>TUE</TD><TD align="right">8</TD></TR></TBODY></TABLE><P></P><P>Want to compare the benchmark like below</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 288px;"><TBODY><TR><TD height="21" width="72">ID</TD><TD width="72">DAY</TD><TD width="72">MONEY</TD><TD width="72">Benchmark</TD></TR><TR><TD align="right" height="21">1</TD><TD>MON</TD><TD align="right">1</TD><TD align="right">7</TD></TR><TR><TD align="right" height="21">1</TD><TD>TUE</TD><TD align="right">2</TD><TD align="right">8</TD></TR><TR><TD align="right" height="21">2</TD><TD>MON</TD><TD align="right">3</TD><TD align="right">7</TD></TR><TR><TD align="right" height="21">2</TD><TD>TUE</TD><TD align="right">4</TD><TD align="right">8</TD></TR><TR><TD align="right" height="21">3</TD><TD>MON</TD><TD align="right">5</TD><TD align="right">7</TD></TR><TR><TD align="right" height="21">3</TD><TD>TUE</TD><TD align="right">6</TD><TD align="right">8</TD></TR><TR><TD align="right" height="21"><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">Benchmark</SPAN></TD><TD>MON</TD><TD align="right">7</TD><TD align="right">7</TD></TR><TR><TD align="right" height="21"><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">Benchmark</SPAN></TD><TD>TUE</TD><TD align="right">8</TD><TD align="right">8</TD></TR></TBODY></TABLE><P></P><P>To achieve this,</P><P>I have selected 'ID' and 'Day' as dimensions,</P><P>'MONEY' is the expression and the benchmark expression sum({$&lt;ID={4}&gt;}MONEY) </P><P>but the result turns out</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="288"><TBODY><TR><TD height="21" width="72">ID</TD><TD width="72">DAY</TD><TD width="72">MONEY</TD><TD width="72">Benchmark</TD></TR><TR><TD align="right" height="21">1</TD><TD>MON</TD><TD align="right">1</TD><TD align="right">0</TD></TR><TR><TD align="right" height="21">1</TD><TD>TUE</TD><TD align="right">2</TD><TD align="right">0</TD></TR><TR><TD align="right" height="21">2</TD><TD>MON</TD><TD align="right">3</TD><TD align="right">0</TD></TR><TR><TD align="right" height="21">2</TD><TD>TUE</TD><TD align="right">4</TD><TD align="right">0</TD></TR><TR><TD align="right" height="21">3</TD><TD>MON</TD><TD align="right">5</TD><TD align="right">0</TD></TR><TR><TD align="right" height="21">3</TD><TD>TUE</TD><TD align="right">6</TD><TD align="right">0</TD></TR><TR><TD align="right" height="21">4</TD><TD>MON</TD><TD align="right">7</TD><TD align="right">7</TD></TR><TR><TD align="right" height="21">4</TD><TD>TUE</TD><TD align="right">8</TD><TD align="right">8</TD></TR></TBODY></TABLE><P></P><P>What is wrong in my work?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Fail-to-show-the-benchmark-value/m-p/1172648#M911178 2020-11-25T16:16:04Z Re: Set Analysis - Fail to show the benchmark value https://community.qlik.com/t5/QlikView/Set-Analysis-Fail-to-show-the-benchmark-value/m-p/1172649#M911179 <HTML><HEAD></HEAD><BODY><P>Try </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(<STRONG>TOTAL&lt;DAY&gt;</STRONG> {$&lt;ID={4}&gt;}MONEY)</SPAN></P></BODY></HTML> Sun, 12 Jun 2016 11:32:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Fail-to-show-the-benchmark-value/m-p/1172649#M911179 swuehl 2016-06-12T11:32:18Z Re: Set Analysis - Fail to show the benchmark value https://community.qlik.com/t5/QlikView/Set-Analysis-Fail-to-show-the-benchmark-value/m-p/1172650#M911180 <HTML><HEAD></HEAD><BODY><P>Let me try,thanks</P></BODY></HTML> Sun, 12 Jun 2016 11:49:47 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Fail-to-show-the-benchmark-value/m-p/1172650#M911180 2016-06-12T11:49:47Z