3 Replies Latest reply: Jan 22, 2014 8:02 AM by Friedrich Hofmann RSS

    Simpleton question - do I need a set_expression here or not?

    Friedrich Hofmann

      Hi,

       

      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!

      Best regards,

       

      DataNibbler