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!