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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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