Expression Logic

sona_sa — Tue, 30 Dec 2014 11:45:33 GMT

Hi I have one report, When I am not doing any selection, Output is correct, But When I am selecting Section ---> COGS Output is mismatching with entire output. I want only COGS data should to display there in reports. Another entire selection is working fine. But Section is not working. So Please help me on the same.

My Expresion :

Period 1 :

=if(GetSelectedCount(Section>1),

(If([P&L Level] = 's' , ' ',sum({Period_1<Section=$::Section,CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))),

If([P&L Level] = 's' , ' ',sum({Period_1<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))

)

Period 2 :

=if(GetSelectedCount(Section>1),

(If([P&L Level] = 's' , ' ',sum({Period_2<Section=$::Section,CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))),

If([P&L Level] = 's' , ' ',sum({Period_2<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))

)

For reference I am attaching with and without selection jpeg file.

Thanks in Advance

topic Expression Logic in QlikView

Expression Logic