Discussion Board for collaboration related to QlikView App Development.
I'm loading data based on phone numbers from a file to analyse. The purpose is basically sorting the data(number of rows) down to dates.
That isn't a problem but what I want to do first, preferably in the load, is to exclude the first 10 rows imported for each distinct phone number.
Where Autonumber(RecNo(),[phone number]) > 10;
May be try something like this
//Just the telephone number with distinct. This will give the number of DISTINCT tel number
[Telephone Number Data.xlsx]
(ooxml, embedded labels, table is Worksheet)
//Left Join the rest of the fields with the 1st load
WHERE Exists([Telephone Number])
Hope this helps