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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change # of columns in Straight Table depending on Cyclic Group selection

I have the following task. I need to create a straight table. This table should have two cyclic groups.

Cyclic Group A should show Column A, Column B, Column C, Column D.

Cyclic Group B should show same Column A (same data as in Column A in Cyclic Group A), same Column B (same data as in Column B in Cyclic Group A), Column E (is not present in Cyclic Group A), column F (is not present in Cyclic Group A).

Is it possible depending on what cyclic group you choose show different columns in straight table?

E.g., I select Cyclic Group A, I see Column A, Column B, Column C, Column D in straight table. I select Cyclic Group B, I see Column A, Column B, Column E, column F.

Thanks!

1 Reply
Anonymous
Not applicable
Author

Certainly possible.

Make the columns (except A and B) conditional, and use conditions

GetCurrentField(YourCycleGroup) = 'A'

GetCurrentField(YourCycleGroup) = 'B'