https://community.qlik.com/t5/QlikView/How-to-create-expresion-for-the-below-requirement/m-p/1755128#M590953 <P>can you pls provide more info?&nbsp; RP level and B reference arent even in the expression.&nbsp; how are all these fields associated?</P> Thu, 22 Oct 2020 18:45:38 GMT edwin 2020-10-22T18:45:38Z https://community.qlik.com/t5/QlikView/How-to-create-expresion-for-the-below-requirement/m-p/1754695#M590952 <P>Hi All, After created the below expression RP Level and B reference filters are not filtering properly =if(RPview='Gross', Sum({ID=, Source=, ID={$(vID) }, Source1={'$(vSource) '}&gt;}Balance)&nbsp;</P><P>ID=1234, Source and Source1=Q1, Q2, Q3 (from different tables&nbsp; &nbsp;RP View ='Gross',&nbsp; and 'Net'&nbsp; Could you please help me</P> Wed, 21 Oct 2020 20:00:16 GMT https://community.qlik.com/t5/QlikView/How-to-create-expresion-for-the-below-requirement/m-p/1754695#M590952 Vamsy1991 2020-10-21T20:00:16Z https://community.qlik.com/t5/QlikView/How-to-create-expresion-for-the-below-requirement/m-p/1755128#M590953 <P>can you pls provide more info?&nbsp; RP level and B reference arent even in the expression.&nbsp; how are all these fields associated?</P> Thu, 22 Oct 2020 18:45:38 GMT https://community.qlik.com/t5/QlikView/How-to-create-expresion-for-the-below-requirement/m-p/1755128#M590953 edwin 2020-10-22T18:45:38Z