Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to remove the condition on If([Exec P&L Level] = 's', '' from my expression ?

Hi All

May i know how to remove the condition on If([Exec P&L Level] = 's', '' from below expression ?:-

Money(RangeSum( Above(RangeSum(Above(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1)), 0, RowNo())))

, -Sum(TOTAL Aggr(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1)), YearMonth))) , $(vMoneyFormatK_GL))

Paul

1 Solution

Accepted Solutions
sunny_talwar

This seems to be working in QV, can your try in QS

=Money(RangeSum(

Above(RangeSum(Above(Sum({<year, month>}[Amount]*-1), 0, RowNo()))),

-Sum(TOTAL Aggr(Sum({<year, month>}[Amount]*-1), YearMonth)))

, $(vMoneyFormatK_GL))

Seems to be working in QS for the selections you have, not sure what happens for other selections

View solution in original post

3 Replies
sunny_talwar

Waiting for the sample

paulyeo11
Master
Master
Author

My QS file

sunny_talwar

This seems to be working in QV, can your try in QS

=Money(RangeSum(

Above(RangeSum(Above(Sum({<year, month>}[Amount]*-1), 0, RowNo()))),

-Sum(TOTAL Aggr(Sum({<year, month>}[Amount]*-1), YearMonth)))

, $(vMoneyFormatK_GL))

Seems to be working in QS for the selections you have, not sure what happens for other selections