topic Re: Conditional if inside expression in QlikView https://community.qlik.com/t5/QlikView/Conditional-if-inside-expression/m-p/367469#M136641 <HTML><HEAD></HEAD><BODY><P>I try to make this in expression:</P><P></P><P>if(UNITY = '%', num(Sum (VALUE),'#.##0,00%'),</P><P>if(UNITY &lt;&gt; '%', num(Sum (VALUE),'#.##0,00')))</P><P></P><P>But not working...</P></BODY></HTML> Mon, 25 Jun 2012 17:32:05 GMT 2012-06-25T17:32:05Z Conditional if inside expression https://community.qlik.com/t5/QlikView/Conditional-if-inside-expression/m-p/367467#M136639 <HTML><HEAD></HEAD><BODY><P>I have a field that indicates whether the value of another column is percentage (%) or unit (U) if % format the value of the expression in percentage format or in number with a decimal point. It has to do with if inside the expression?</P></BODY></HTML> Mon, 25 Jun 2012 17:18:43 GMT https://community.qlik.com/t5/QlikView/Conditional-if-inside-expression/m-p/367467#M136639 2012-06-25T17:18:43Z Re: Conditional if inside expression https://community.qlik.com/t5/QlikView/Conditional-if-inside-expression/m-p/367468#M136640 <HTML><HEAD></HEAD><BODY><P>See attached for a small example.</P><P></P><P>Hope it helps.</P></BODY></HTML> Mon, 25 Jun 2012 17:27:04 GMT https://community.qlik.com/t5/QlikView/Conditional-if-inside-expression/m-p/367468#M136640 2012-06-25T17:27:04Z Re: Conditional if inside expression https://community.qlik.com/t5/QlikView/Conditional-if-inside-expression/m-p/367469#M136641 <HTML><HEAD></HEAD><BODY><P>I try to make this in expression:</P><P></P><P>if(UNITY = '%', num(Sum (VALUE),'#.##0,00%'),</P><P>if(UNITY &lt;&gt; '%', num(Sum (VALUE),'#.##0,00')))</P><P></P><P>But not working...</P></BODY></HTML> Mon, 25 Jun 2012 17:32:05 GMT https://community.qlik.com/t5/QlikView/Conditional-if-inside-expression/m-p/367469#M136641 2012-06-25T17:32:05Z