topic IF and Set Analysis expression problem in QlikView https://community.qlik.com/t5/QlikView/IF-and-Set-Analysis-expression-problem/m-p/463468#M560921 <HTML><HEAD></HEAD><BODY><P>I have a number of problems which I have broken down and created individual solutions but I am unable to apply them together with consistent results.</P><P></P><P>1. I want to create a straight or pivot table that selects one field from a dimension. The Set Analysis express solution would be SUM ({$&lt; [AR Group] = 'Points'}&gt;} [AG Data]). Or the IF express solution would be IF([AG Group] = 'Points', 0)</P><P></P><P></P><P>2. I was trying to find a way to collapse or remove columns and rows in a pivot table. This does not seem doable.&nbsp; But I can remove data by applying a conditional IF expression in a straight table and ticking 'Suppress When Value is Null':&nbsp; IF (SUM ([AG Data]/[Target Data] &lt; 0.6, [AG Data], IF (SUM ( [AG Data]/[Target Data] &gt; 0.8, [AG Data], 0))</P><P></P><P>I understand Set Analysis does not allow conditional elements. Nor can I see how to use Add Calculated Expression in the Dimensions tab in this instance.</P><P></P><P>Is there a way to join the two IF statements to get the desired results?</P></BODY></HTML> Wed, 17 Apr 2013 13:33:23 GMT simongoodman 2013-04-17T13:33:23Z IF and Set Analysis expression problem https://community.qlik.com/t5/QlikView/IF-and-Set-Analysis-expression-problem/m-p/463468#M560921 <HTML><HEAD></HEAD><BODY><P>I have a number of problems which I have broken down and created individual solutions but I am unable to apply them together with consistent results.</P><P></P><P>1. I want to create a straight or pivot table that selects one field from a dimension. The Set Analysis express solution would be SUM ({$&lt; [AR Group] = 'Points'}&gt;} [AG Data]). Or the IF express solution would be IF([AG Group] = 'Points', 0)</P><P></P><P></P><P>2. I was trying to find a way to collapse or remove columns and rows in a pivot table. This does not seem doable.&nbsp; But I can remove data by applying a conditional IF expression in a straight table and ticking 'Suppress When Value is Null':&nbsp; IF (SUM ([AG Data]/[Target Data] &lt; 0.6, [AG Data], IF (SUM ( [AG Data]/[Target Data] &gt; 0.8, [AG Data], 0))</P><P></P><P>I understand Set Analysis does not allow conditional elements. Nor can I see how to use Add Calculated Expression in the Dimensions tab in this instance.</P><P></P><P>Is there a way to join the two IF statements to get the desired results?</P></BODY></HTML> Wed, 17 Apr 2013 13:33:23 GMT https://community.qlik.com/t5/QlikView/IF-and-Set-Analysis-expression-problem/m-p/463468#M560921 simongoodman 2013-04-17T13:33:23Z