topic Re: How to remove/hide row when column 1 have -ve value in QlikView

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

paulyeo11 — Mon, 19 Sep 2016 08:24:56 GMT

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

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

paulyeo11 — Mon, 19 Sep 2016 08:25:47 GMT

my qvw

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

sunny_talwar — Mon, 19 Sep 2016 08:37:32 GMT

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)))

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

Anil_Babu_Samineni — Mon, 19 Sep 2016 08:41:45 GMT

Try sometthing like If(Expression >0, Expression)

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

paulyeo11 — Mon, 19 Sep 2016 08:43:06 GMT

Hi sunny

Thank you very much it work.

Paul

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

anushree1 — Mon, 19 Sep 2016 08:46:46 GMT

Hi,

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