topic Re: Simpleton question - do I need a set_expression here or not? in QlikView

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

datanibbler — Wed, 22 Jan 2014 10:45:40 GMT

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

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

alexandros17 — Wed, 22 Jan 2014 11:07:25 GMT

Hi,

If there is a selection box in which you choose the year, even the chart with the sum expression will sum data of the selected year; otherwise,the sum will add all values for all the fields in the table obtained cocatenating the 2 original tables

Hope it helps

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

hic — Wed, 22 Jan 2014 12:53:16 GMT

If you have a field "Year" that correctly defines the relevant records, e.g.

AllData:

Load '2013' as Year, * From File2013.txt ;

Concatenate

Load '2014' as Year, * From File2014.txt ;

then you don't need any Set Analysis.

HIC

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

datanibbler — Wed, 22 Jan 2014 13:02:08 GMT

Thanks a lot!

I thought so. Just wasn't sure anymore.

Best regards,

DataNibbler