https://community.qlik.com/t5/QlikView/Need-help-with-set-expression/m-p/2073330#M1223742 <P>I am new to qliksense and I'm trying out a scenario as part of my learning. I have two tables Sales(contains Sales_Date) and Target(contains Target_Year and Target_Value). Sales table has values for every day and Target has year level data. I'm trying to create a table visual with both data combined. So the table visual will have the following columns: Sales_Date Target_Value</P> <P>Since the Target table has year level data, I'm trying to bring Target_Value into the table visual using the below set expression in a measure =Sum({&lt;Target_Year = {$(=Year(Date(Sales_Date)))}&gt;}Target_Value)</P> <P>This doesn't seem to work and I get no value. The expression editor doesn't throw any error. The next option would be to create a Sales_Year column in the Sales table and associate it with the Target_Year in Target table to get the corresponding Target_Value. But I would like to understand why the above expression doesn't work. Do set expression not work in row level? Any guidance is greatly appreciated.</P> <P>Thank you.</P> Fri, 19 May 2023 13:57:17 GMT dinghankar 2023-05-19T13:57:17Z https://community.qlik.com/t5/QlikView/Need-help-with-set-expression/m-p/2073330#M1223742 <P>I am new to qliksense and I'm trying out a scenario as part of my learning. I have two tables Sales(contains Sales_Date) and Target(contains Target_Year and Target_Value). Sales table has values for every day and Target has year level data. I'm trying to create a table visual with both data combined. So the table visual will have the following columns: Sales_Date Target_Value</P> <P>Since the Target table has year level data, I'm trying to bring Target_Value into the table visual using the below set expression in a measure =Sum({&lt;Target_Year = {$(=Year(Date(Sales_Date)))}&gt;}Target_Value)</P> <P>This doesn't seem to work and I get no value. The expression editor doesn't throw any error. The next option would be to create a Sales_Year column in the Sales table and associate it with the Target_Year in Target table to get the corresponding Target_Value. But I would like to understand why the above expression doesn't work. Do set expression not work in row level? Any guidance is greatly appreciated.</P> <P>Thank you.</P> Fri, 19 May 2023 13:57:17 GMT https://community.qlik.com/t5/QlikView/Need-help-with-set-expression/m-p/2073330#M1223742 dinghankar 2023-05-19T13:57:17Z https://community.qlik.com/t5/QlikView/Need-help-with-set-expression/m-p/2073475#M1223743 <P>Hi, " " in modifiers are used for evaluated values.</P> <P>=Sum({&lt;Target_Year = {<FONT color="#FF0000"><STRONG>"</STRONG></FONT>$(=Year(Date(Sales_Date)))<FONT color="#FF0000"><STRONG>"</STRONG></FONT>}&gt;}Target_Value)</P> Sat, 20 May 2023 07:44:57 GMT https://community.qlik.com/t5/QlikView/Need-help-with-set-expression/m-p/2073475#M1223743 BrunPierre 2023-05-20T07:44:57Z