Discussion Board for collaboration related to QlikView App Development.
Just wanted to know if there's an easy way ( Im guessing a map ) to do the folllowing :
So I have for instance
Date, Account_No , Salesperson
Now I have a separate list of 'Account_No' in an excel sheet. And it is only these account nos that should be picked up.
Manually I can do this by taking the list and concatenating with a comma at the end of each line and adding this to a where match clause in the script. Can this be done better ?
Try like this
View solution in original post
May be I think first you should load the valid account excel. Next, you load the Date, Account_No , Salesperson file and use Where clause as 'Where Exists(Account_No)'
Thanks Avinash - this works excellent
Cool...Happy to hear that