topic Re: Value in straight table is changed when filter dimensions in QlikView https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109062#M762877 <HTML><HEAD></HEAD><BODY><P>Which one of the two is the correct value?</P></BODY></HTML> Fri, 20 Jul 2018 11:38:03 GMT sunny_talwar 2018-07-20T11:38:03Z Value in straight table is changed when filter dimensions https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109059#M762874 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I have a problem with my straight table, the value when I show all rows different with when I choose one row.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">9</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">8</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">7</TD></TR></TBODY></TABLE><P></P><P>When I choose A , then</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">9.8</TD></TR></TBODY></TABLE><P></P><P>My set analysis is: sum(if( aggr(nodistinct $(type),Client)='New',Fee)) </P><P></P><P>thanks for your help </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109059#M762874 phongnnguyen 2020-11-25T16:16:04Z Re: Value in straight table is changed when filter dimensions https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109060#M762875 <HTML><HEAD></HEAD><BODY><P>Provide raw data table as for your example we cannot provide any solutions.</P><P>Thank you in advance!</P></BODY></HTML> Fri, 20 Jul 2018 05:09:51 GMT https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109060#M762875 MindaugasBacius 2018-07-20T05:09:51Z Re: Value in straight table is changed when filter dimensions https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109061#M762876 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>may be format of header 2 in first case is with 0 decimal</P><P></P><P>regards</P></BODY></HTML> Fri, 20 Jul 2018 07:19:26 GMT https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109061#M762876 ogautier62 2018-07-20T07:19:26Z Re: Value in straight table is changed when filter dimensions https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109062#M762877 <HTML><HEAD></HEAD><BODY><P>Which one of the two is the correct value?</P></BODY></HTML> Fri, 20 Jul 2018 11:38:03 GMT https://community.qlik.com/t5/QlikView/Value-in-straight-table-is-changed-when-filter-dimensions/m-p/109062#M762877 sunny_talwar 2018-07-20T11:38:03Z