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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
0 Replies