This content has been marked as final. Show 3 replies
I have just concatenated data_lists from two different Excel files: One for 2013, one for 2014.
=> The issue is, there are quite a few more fields in the one for 2014, so there is some structural assymetry
<=> The most important fields are the same and have the same name through both years.
=> When I have a sum([field]) function in the script now, will QlikView automatically react to the user_selection of either 2013 or 2014 and sum only the records in that half of the table or do I need a set_expression here?
Thanks a lot!