Test: LOAD * INLINE [ Client Name, Referred By, Client Segment, Product, Date ABC Ltd, Grape United Business, Car, 01/02/2017 Grape United, , Corporate, Car, 01/03/2017 Beefy Times, Signal Limited, Business, Boat, 16/06/2017 Soggy Trousers, Signal Limited, Business, Trailer, 01/02/2017 Signal Limited, , Corporate, Boat, 31/03/2017 Parrot Inc, , Corporate, Boat, 17/07/2017 Elephant Hardware, , Business, Car, 23/09/2017 Beefy Times Signal Limited, Business, Boat, 01/02/2017 ]; noconcatenate LOAD * Resident Test where [Client Segment]= 'Corporate'; DROP Table Test;
Not clear about you final expected result. Do you want something like below? then use the above script
I should have clarified sorry - it's a dynamic table. It gets updated remotely every day (we use Qlik Sense Server).
So the script can't be that specific.
As far as the expected result, it will be a visualisation that show the number of distinct "Referring Customers" for any defined time period.
So in my example (for example), it would be 2 for February, 2 for March, and for Year to Date 3. There is some other script being used to define dates etc.