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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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