topic Variables and Flags in App Development https://community.qlik.com/t5/App-Development/Variables-and-Flags/m-p/1334559#M29209 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to exclude some types of my calculated measure.</P><P></P><P>So I need to define a flag. My approach was to define a variable in the UI.</P><P></P><P><STRONG>vFlag:</STRONG> if( TYPE='A', 1,0)</P><P></P><P>Then I created a master element Using this Formula (and lots of variations):</P><P></P><P><STRONG>mRevenue:</STRONG></P><P>Sum(If(($(<STRONG>vFlag</STRONG>),REVENUE,0)))</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Sum(If(($(<STRONG>vFlag</STRONG>)=1,REVENUE,0)))</SPAN></P><P></P><P>There is no syntax error. No results. </P><P></P><P>What's wrong here ?</P><P></P><P>And what are your experiences with the handling of measures in the UI ?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 18 Apr 2017 14:47:23 GMT 2017-04-18T14:47:23Z Variables and Flags https://community.qlik.com/t5/App-Development/Variables-and-Flags/m-p/1334559#M29209 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to exclude some types of my calculated measure.</P><P></P><P>So I need to define a flag. My approach was to define a variable in the UI.</P><P></P><P><STRONG>vFlag:</STRONG> if( TYPE='A', 1,0)</P><P></P><P>Then I created a master element Using this Formula (and lots of variations):</P><P></P><P><STRONG>mRevenue:</STRONG></P><P>Sum(If(($(<STRONG>vFlag</STRONG>),REVENUE,0)))</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Sum(If(($(<STRONG>vFlag</STRONG>)=1,REVENUE,0)))</SPAN></P><P></P><P>There is no syntax error. No results. </P><P></P><P>What's wrong here ?</P><P></P><P>And what are your experiences with the handling of measures in the UI ?</P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 18 Apr 2017 14:47:23 GMT https://community.qlik.com/t5/App-Development/Variables-and-Flags/m-p/1334559#M29209 2017-04-18T14:47:23Z