topic Re: Hide columns based on cycle group in QlikView https://community.qlik.com/t5/QlikView/Hide-columns-based-on-cycle-group/m-p/459121#M559923 <HTML><HEAD></HEAD><BODY><P>Your if statement isn't complete. It only contains the condition, not the true and false result expressions:</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">if(getcurrentfield([Product Cycle]) = 'Green',1,0)</SPAN></P></BODY></HTML> Tue, 14 May 2013 18:51:50 GMT Gysbert_Wassenaar 2013-05-14T18:51:50Z Hide columns based on cycle group https://community.qlik.com/t5/QlikView/Hide-columns-based-on-cycle-group/m-p/459120#M559922 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>I go to Presentation tab and use:</P><P></P><P>if(getcurrentfield([Product Cycle]) = 'Green')</P><P></P><P>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.</P><P></P><P>Can you help?</P></BODY></HTML> Tue, 14 May 2013 18:38:32 GMT https://community.qlik.com/t5/QlikView/Hide-columns-based-on-cycle-group/m-p/459120#M559922 2013-05-14T18:38:32Z Re: Hide columns based on cycle group https://community.qlik.com/t5/QlikView/Hide-columns-based-on-cycle-group/m-p/459121#M559923 <HTML><HEAD></HEAD><BODY><P>Your if statement isn't complete. It only contains the condition, not the true and false result expressions:</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">if(getcurrentfield([Product Cycle]) = 'Green',1,0)</SPAN></P></BODY></HTML> Tue, 14 May 2013 18:51:50 GMT https://community.qlik.com/t5/QlikView/Hide-columns-based-on-cycle-group/m-p/459121#M559923 Gysbert_Wassenaar 2013-05-14T18:51:50Z