The SA3 tells me for each callid of the table T1 if the C_creation_year and C_creation_month of the callid fits with the selected P_year and P_month : I get '1' if it fits. Then I replaced SA1 and SA2 by SA3. I finally made condition on SA3 to display the Callid with SA3 = 1.
=> It works fine
Q1 : I don't understand why I get a little red tic under the second paranthesis of S1 and S2. Is there something wrong in my expressions ?
Q2 : When I select P_year = 2011 and 2012, I get SA1=1 for the whole callid with C_creation_year = 2011 or 2012 but when I select no P_year, I get systematically SA1 = 0. I was thinking that giving no selection in a selection lists means 'I want all'. Is it not the case ? What could I do in SA1 to get all Callid when I select no P_year ?
How can I hide my ES4 expression column ?
Q4 : General question
Is there any other ways to filter on table (T1) with a filter based on P_year (SL1) and P_month (SL2) without links between the QV tables 'Calls' and 'Period') ?