Question on best practice for set analysis

[#1]

Hi Qlik Community,

I have a question regarding the most efficient way to build a multi-table report.  I have a report with 4 tables, one table for each of the last 4 years.  Each table is identical and allows for the user to compare metrics across each of the 4 years.  I have a dynamic indicator to always identify the last 4 years.  My current solution is to apply set analysis to each of the 8 metrics in each of the tables.  Is there an easier way to apply the same principle of set analysis to the entire table so that I don't have to apply the set analysis in each of the metrics?  Seems like there should be a more efficient way.

For Example:

Table 1

sum( { < [YR_IND] = {'Current Year'}, [Metric1])

sum( { < [YR_IND] = {'Current Year'}, [Metric2])

sum( { < [YR_IND] = {'Current Year'}, [Metric3])

sum( { < [YR_IND] = {'Current Year'}, [Metric4])

sum( { < [YR_IND] = {'Current Year'}, [Metric5])

sum( { < [YR_IND] = {'Current Year'}, [Metric6])

sum( { < [YR_IND] = {'Current Year'}, [Metric7])

sum( { < [YR_IND] = {'Current Year'}, [Metric8])

Table 2

sum( { < [YR_IND] = {'Last Year'}, [Metric1])

sum( { < [YR_IND] = {'Last Year'}, [Metric2])

sum( { < [YR_IND] = {'Last Year'}, [Metric3])

sum( { < [YR_IND] = {'Last Year'}, [Metric4])

sum( { < [YR_IND] = {'Last Year'}, [Metric5])

sum( { < [YR_IND] = {'Last Year'}, [Metric6])

sum( { < [YR_IND] = {'Last Year'}, [Metric7])

sum( { < [YR_IND] = {'Last Year'}, [Metric8])

Hope this makes sense!