5 Replies Latest reply: Sep 19, 2016 4:46 AM by Anushree Shetty RSS

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

    PAUL YEO

      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