topic Re: If statement help in QlikView https://community.qlik.com/t5/QlikView/If-statement-help/m-p/1363297#M824775 <HTML><HEAD></HEAD><BODY><P>u can try this as your dimension</P><P></P><P>If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)</P></BODY></HTML> Tue, 25 Jul 2017 07:00:57 GMT shiveshsingh 2017-07-25T07:00:57Z If statement help https://community.qlik.com/t5/QlikView/If-statement-help/m-p/1363295#M824773 <HTML><HEAD></HEAD><BODY><P>Trying to filter out two fields in an if statement as a dimension on a table.</P><P></P><P>I just want to filter out 'Distribution Orders' and 'Decon - Totes' from the 'Program_Dash' field.</P><P></P><P><IMG alt="select.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/171228_select.PNG" style="width: 620px; height: 150px;" /></P><P></P><P><IMG alt="Capture4.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/171229_Capture4.PNG" style="width: 620px; height: 222px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/If-statement-help/m-p/1363295#M824773 joshrussin 2020-11-25T16:16:04Z Re: If statement help https://community.qlik.com/t5/QlikView/If-statement-help/m-p/1363296#M824774 <HTML><HEAD></HEAD><BODY><P>May be like this in your dimension</P><P><STRONG>If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)</STRONG></P><P></P><P>Or use set analysis in your expression</P><P><STRONG>Sum(<SPAN style="color: #ff0000;">{&lt;Program_Dash = {'Distribution Orders', 'Decon - Totes'}&gt;}</SPAN>Measure)</STRONG></P></BODY></HTML> Tue, 25 Jul 2017 00:30:41 GMT https://community.qlik.com/t5/QlikView/If-statement-help/m-p/1363296#M824774 sunny_talwar 2017-07-25T00:30:41Z Re: If statement help https://community.qlik.com/t5/QlikView/If-statement-help/m-p/1363297#M824775 <HTML><HEAD></HEAD><BODY><P>u can try this as your dimension</P><P></P><P>If(Match(Program_Dash, 'Distribution Orders', 'Decon - Totes'), Program_Dash)</P></BODY></HTML> Tue, 25 Jul 2017 07:00:57 GMT https://community.qlik.com/t5/QlikView/If-statement-help/m-p/1363297#M824775 shiveshsingh 2017-07-25T07:00:57Z