topic if statement on Dimension in QlikView https://community.qlik.com/t5/QlikView/if-statement-on-Dimension/m-p/465306#M486170 <HTML><HEAD></HEAD><BODY><P>Hi, I am working on pivot table, on the dimension tab.</P><P></P><P>Example, my variable in the field consist of A,B,C,D</P><P></P><P>Therefore, if(myfield = 'A','A','others')</P><P></P><P>others will tabulate B,C,D for me</P><P></P><P>However,i would want my 'others' to consist of everything in that variable, say A,B,C,D.</P><P></P><P>any help is appreciated, thanks</P></BODY></HTML> Thu, 18 Apr 2013 02:31:12 GMT n1ef5ng1 2013-04-18T02:31:12Z if statement on Dimension https://community.qlik.com/t5/QlikView/if-statement-on-Dimension/m-p/465306#M486170 <HTML><HEAD></HEAD><BODY><P>Hi, I am working on pivot table, on the dimension tab.</P><P></P><P>Example, my variable in the field consist of A,B,C,D</P><P></P><P>Therefore, if(myfield = 'A','A','others')</P><P></P><P>others will tabulate B,C,D for me</P><P></P><P>However,i would want my 'others' to consist of everything in that variable, say A,B,C,D.</P><P></P><P>any help is appreciated, thanks</P></BODY></HTML> Thu, 18 Apr 2013 02:31:12 GMT https://community.qlik.com/t5/QlikView/if-statement-on-Dimension/m-p/465306#M486170 n1ef5ng1 2013-04-18T02:31:12Z