topic Calculated Dimesion - Syntax in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimesion-Syntax/m-p/394909#M558430 <HTML><HEAD></HEAD><BODY><P>Hi i have a diagram whereby i wish to restrict my dataset to two values.</P><P></P><P>=if ([Tillv/köp-kod]= 3 and [Tillv/köp-kod] = 6, [Tillv/köp-kod])</P><P></P><P>however i see that in the column i recieve - as a value. </P><P></P><P>is the syntax potentially wrong?</P><P></P><P><SPAN style="font-size: 10pt;">Best,</SPAN></P><P><SPAN style="font-size: 10pt;">Bradley<BR /></SPAN></P></BODY></HTML> Wed, 22 May 2013 09:30:28 GMT 2013-05-22T09:30:28Z Calculated Dimesion - Syntax https://community.qlik.com/t5/QlikView/Calculated-Dimesion-Syntax/m-p/394909#M558430 <HTML><HEAD></HEAD><BODY><P>Hi i have a diagram whereby i wish to restrict my dataset to two values.</P><P></P><P>=if ([Tillv/köp-kod]= 3 and [Tillv/köp-kod] = 6, [Tillv/köp-kod])</P><P></P><P>however i see that in the column i recieve - as a value. </P><P></P><P>is the syntax potentially wrong?</P><P></P><P><SPAN style="font-size: 10pt;">Best,</SPAN></P><P><SPAN style="font-size: 10pt;">Bradley<BR /></SPAN></P></BODY></HTML> Wed, 22 May 2013 09:30:28 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimesion-Syntax/m-p/394909#M558430 2013-05-22T09:30:28Z Re: Calculated Dimesion - Syntax https://community.qlik.com/t5/QlikView/Calculated-Dimesion-Syntax/m-p/394910#M558431 <HTML><HEAD></HEAD><BODY><P>If you want only 3 and 6 value you can use </P><P>if(WildMatch([Tillv/köp-kod],'3','6'),field1) else if you want the range between 3 and 6 you can go with</P><P>if([Tillv/köp-kod]&gt;=3 and [Tillv/köp-kod]&lt;=6,field1)</P></BODY></HTML> Wed, 22 May 2013 10:08:20 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimesion-Syntax/m-p/394910#M558431 sivarajs 2013-05-22T10:08:20Z