topic Anyway to exclude some data from a cyclic group dimension? in QlikView https://community.qlik.com/t5/QlikView/Anyway-to-exclude-some-data-from-a-cyclic-group-dimension/m-p/451098#M168328 <HTML><HEAD></HEAD><BODY><P>Hello Eveyrone,</P><P></P><P>I create a pivote table by using a cyclic group as dimension, such as Product, Product Line. I want show different product and product line for different year. </P><P>For example, for year 2009, I need to show Product1 and Product Line1, Product2 and Product Line2, Product3 and Product Line3. For 2010, I need to show Product1 and Product Line1, Product3 and Product Line3.</P><P></P><P>What is the best way to create this pivote table.</P><P></P><P>Thanks,</P><P>Dust</P></BODY></HTML> Thu, 24 Jan 2013 04:13:01 GMT 2013-01-24T04:13:01Z Anyway to exclude some data from a cyclic group dimension? https://community.qlik.com/t5/QlikView/Anyway-to-exclude-some-data-from-a-cyclic-group-dimension/m-p/451098#M168328 <HTML><HEAD></HEAD><BODY><P>Hello Eveyrone,</P><P></P><P>I create a pivote table by using a cyclic group as dimension, such as Product, Product Line. I want show different product and product line for different year. </P><P>For example, for year 2009, I need to show Product1 and Product Line1, Product2 and Product Line2, Product3 and Product Line3. For 2010, I need to show Product1 and Product Line1, Product3 and Product Line3.</P><P></P><P>What is the best way to create this pivote table.</P><P></P><P>Thanks,</P><P>Dust</P></BODY></HTML> Thu, 24 Jan 2013 04:13:01 GMT https://community.qlik.com/t5/QlikView/Anyway-to-exclude-some-data-from-a-cyclic-group-dimension/m-p/451098#M168328 2013-01-24T04:13:01Z