7 Replies Latest reply: Sep 17, 2016 1:46 PM by Jacinto Fernandez Nogales RSS

    Exclude selection listbox.

    Jacinto Fernandez Nogales

      Hi everyone,

       

      I send a question to see if anyone can help me...

      I have the following data model:

       

      FILE_ORDERS:

      LOAD:

           [Id ORDER],

           [Customer],

           [NIF]

           [Sales]

           :

           :

      FROM .......

       

      and:

       

      Table_Blocked_Customers:

      Load Distinct * inline

      [

      NIF| Customer_bloked

      XXXXXXXX| CUSTOMER1

      XXYYXXYY| CUSTOMER5

      ](delimiter is '|');


      In my QView report I have diferents charts with different calculations. What I want is to have a listbox with blocked customers (listbox with field associated "Customer_bloked") and when I select one/two or alls customers in the listbox then exclude from the calculations (in the charts that I said above) this customers. I've explained ??


      One example:


      Customer 1     Sales:5

      Customer 2     Sales:3

      Customer 3     Sales:2

      Customer 5     Sales:4

      Customer 6     Sales:8


      if I don't select any blocked customers, f.ex. the sum of Sales will be 5+3+2+4+8= 22. But if I select in the listbox an blocked customer, f.ex. Customer5, the sum should be: 5+3+2+8=18.


      Thanks in advance.