How to remove/hide row when column 1 have -ve value

[paulyeo11]

Hi All

Sunny have help me on below post :-

https://community.qlik.com/thread/232601

My Table column 1 expression :-

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1))

My Table column 2 expression :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) <> 0,

Sum(if(L5M='-1',sales)))

I need to remove the 1 Column 180 days , those row with -ve value. meaning i need to remove last 4 row.

I try modify My Table column 2 expression :-

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,

Sum(if(L5M='-1',sales)))

But it does not work.

Paul

[paulyeo11]

my qvw

[sunny_talwar · Accepted solution]

You probably need the same if condition for your first expression:

If(Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)) > 0,

Sum({<SEGMENT -= {'Related Coy'},aging_ar = {'>=181'} >}total_ar  * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD'), 1.64, (1/24), 1.25, 0.012, 1/24, 1)))

[Anil_Babu_Samineni]

Try sometthing like If(Expression >0, Expression)

[paulyeo11]

Hi sunny

Thank you very much it work.

Paul

[anushree1]

Hi,

You could probably use the Dimension limits tab as in the attachment