Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Anyway to exclude some data from a cyclic group dimension?

Hello Eveyrone,

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.

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.

What is the best way to create this pivote table.

Thanks,

Dust

0 Replies