Set analysis to change tables based on filter selection

[chibi]

Hi Im trying to switch the data coming from which table based on a current filter selection. In this case if any user chooses any value from the filter product it should take from session-product table instead of the actual session table 

 why is the expression incorrect? 

[anat]

getcurrentselection should be closed with ()

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Field...

[chibi · Accepted solution]

I found the correct syntax and it works now. Here's the formula for reference; 

if (GetFieldSelections(Product)=Product,sum(game_session_count),sum(session_count))