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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide columns based on cycle group

I have a Chart table where the first column is a cycle group (dimension). I am trying to hide/show some columns based on the option chosen in the cycle group.

I go to Presentation tab and use:

if(getcurrentfield([Product Cycle]) = 'Green')

It seems the group name is not recognized. [Product Cycle] is not recognized and shows as wrong when typing the expression.I have checked many times the spelling.

Can you help?

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Your if statement isn't complete. It only contains the condition, not the true and false result expressions:

if(getcurrentfield([Product Cycle]) = 'Green',1,0)


talk is cheap, supply exceeds demand