topic Setting Variables with if statement in QlikView https://community.qlik.com/t5/QlikView/Setting-Variables-with-if-statement/m-p/253420#M96041 <HTML><HEAD></HEAD><BODY><P>is it possible to set variables with if statement and how do i do that in load statement or directly though variable overview.</P><P></P><P>Statement would be:</P><P></P><P>if([Segment]= 'External Wholesale', [Company Type])</P><P></P><P>I have to do it for another 5 segments as doing if clause in Dimension does not execute exceptions correctly in my complicated Pivot tables.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Nov 2011 11:00:24 GMT Anonymous 2011-11-24T11:00:24Z Setting Variables with if statement https://community.qlik.com/t5/QlikView/Setting-Variables-with-if-statement/m-p/253420#M96041 <HTML><HEAD></HEAD><BODY><P>is it possible to set variables with if statement and how do i do that in load statement or directly though variable overview.</P><P></P><P>Statement would be:</P><P></P><P>if([Segment]= 'External Wholesale', [Company Type])</P><P></P><P>I have to do it for another 5 segments as doing if clause in Dimension does not execute exceptions correctly in my complicated Pivot tables.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Nov 2011 11:00:24 GMT https://community.qlik.com/t5/QlikView/Setting-Variables-with-if-statement/m-p/253420#M96041 Anonymous 2011-11-24T11:00:24Z