Question on best practice for set analysis

Wed, 29 Oct 2014 15:37:50 GMT

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!

topic Question on best practice for set analysis in QlikView

Question on best practice for set analysis