Expression Help

sona_sa — Wed, 14 Jan 2015 17:05:22 GMT

Hi,

I have a pivot table, Selection is lock, Please Unlock the apps.

Selection à Year 2014 à Country – Israel, GL ACoount à TOTAL CASH AND CASH EQUIVALENTS – 724622.32 is coming.

By Using this Expression:

if(GetSelectedCount(Section1=1),
(If([BS Level] = 's' , ' ',Sum({$<MonthNum={$(vMinMonth)}>} $(OpenBalanceExpression) )))+
(If([BS Level] = 's' , ' ',sum({<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName,Section1=$::Section1>}($(DebitExpression)-$(CreditExpression))))),
(If([BS Level] = 's' , ' ',sum({<CompanyName=$::CompanyName,Department=$::Department,Format=$::Format,Format_Data1=$::Format_Data1,Format_Data2=$::Format_Data2,SourceName=$::SourceName,TransTypeName=$::TransTypeName>}($(DebitExpression)-$(CreditExpression))))))

But Output is wrong : It Should be : 1,709,807 on the same selection.

But when I am using the this expression Output is coming correct but my Report chart format is mismatch and output is correct.

Expression :

Num(If([BS Level]='s',' ',(Sum({$<MonthNum={$(vMinMonth)},Year=$::Year,Month=$::Month,CompanyName=$::CompanyName>} $(OpenBalanceExpression) ))),'##.##')
+
Num((If([BS Level]='s',' ',(sum({$<Year=$::Year,Month=$::Month,CompanyName=$::CompanyName>}$(DebitExpression)))))-(If([BS Level]='s',' ',(sum({$<Year=$::Year,Month=$::Month,CompanyName=$::CompanyName>}$(CreditExpression))))),'##.##')

But I required same report format with correct output.

For more ref. please find the attached qvw and jpeg.

Thanks.

topic Expression Help in QlikView

Expression Help