4 Replies Latest reply: Nov 29, 2016 10:08 AM by patrico mesri RSS

    Help with table not showing the results

    patrico mesri

      Hi experts of Qlik.

       

      • The first table has Society, Code, Customer.

      Column "No Vencido" is:

       

      if(today( 2)<=(BLDAT+ZBD1T), Sum({<"SHKZG"={S}>} DMBTR)-Sum({<"SHKZG"={H}>} DMBTR))

       

      The following columns are more or less the same but the range is different:

       

      if((TODAY( 2)-(BLDAT+ZBD1T))>0 and (TODAY( 2)-(BLDAT+ZBD1T))<=30,Sum({<"SHKZG"={S}>} DMBTR)-Sum({<"SHKZG"={H}>} DMBTR))

       

      • The second table, if I remove Society column, I don't get any results at all.

       

       

      This is what I want the table to show: One single row for the customer.

      CodeCustomerNo Vencido0-3031-6061-9091-180>180
      1000012FIDESA SA1133$-----540$

       

      If I leave the society field, it gives me more than one row due to the fact that there are different societies which is correct but I remove it, it doesn't sum.

      Thank you in advance.

      Regards.