https://community.qlik.com/t5/QlikView/Formula/m-p/2044319#M1222835 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/220271">@D_SARANYA5</a> </P> <P>This for starters: <A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" target="_self">Set analysis and set expressions</A>&nbsp;</P> Thu, 02 Mar 2023 08:58:26 GMT BrunPierre 2023-03-02T08:58:26Z https://community.qlik.com/t5/QlikView/Formula/m-p/2044275#M1222831 <P>Hello All,</P> <P>I'm new to Qlik sense... I would like to know what formula should we use to calculate the value of particular line items in a column.</P> <P>Eg: ref below table... I would like to calculate only the value of A &amp; B...</P> <TABLE width="205"> <TBODY> <TR> <TD width="73">Date</TD> <TD width="83">Classification</TD> <TD width="49">Value $</TD> </TR> <TR> <TD>01/01/2023</TD> <TD>A</TD> <TD>&nbsp;22.00</TD> </TR> <TR> <TD>02/01/2023</TD> <TD>B</TD> <TD>&nbsp;33.00</TD> </TR> <TR> <TD>03/01/2023</TD> <TD>C</TD> <TD>&nbsp;32.00</TD> </TR> <TR> <TD>04/01/2023</TD> <TD>D</TD> <TD>&nbsp;34.00</TD> </TR> <TR> <TD>04/01/2023</TD> <TD>E</TD> <TD>&nbsp;46.00</TD> </TR> <TR> <TD>06/01/2023</TD> <TD>A</TD> <TD>&nbsp;75.00</TD> </TR> <TR> <TD>07/01/2023</TD> <TD>B</TD> <TD>&nbsp;18.00</TD> </TR> <TR> <TD>09/01/2023</TD> <TD>C</TD> <TD>&nbsp;92.00</TD> </TR> <TR> <TD>10/01/2023</TD> <TD>D</TD> <TD>&nbsp;&nbsp; 1.00</TD> </TR> <TR> <TD>11/01/2023</TD> <TD>E</TD> <TD>&nbsp;23.00</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Expecting all your assistance.</P> Thu, 02 Mar 2023 07:22:48 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/2044275#M1222831 D_SARANYA5 2023-03-02T07:22:48Z https://community.qlik.com/t5/QlikView/Formula/m-p/2044319#M1222835 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/220271">@D_SARANYA5</a> </P> <P>This for starters: <A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm" target="_self">Set analysis and set expressions</A>&nbsp;</P> Thu, 02 Mar 2023 08:58:26 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/2044319#M1222835 BrunPierre 2023-03-02T08:58:26Z https://community.qlik.com/t5/QlikView/Formula/m-p/2044438#M1222838 <P>Thank you..... It helps <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 02 Mar 2023 12:22:03 GMT https://community.qlik.com/t5/QlikView/Formula/m-p/2044438#M1222838 D_SARANYA5 2023-03-02T12:22:03Z