topic Filtering values in dimension in QlikView https://community.qlik.com/t5/QlikView/Filtering-values-in-dimension/m-p/390122#M145570 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a pivot table(chart) in which I am using a cyclic group to cycle through a few dimensions. Is there a way to only show certiain vales of a dimension? For example, let's say that the cyclic group has 3 dimensions FIELD A, FIELD B, FIELD C. Users can cycle through these 3 filds in the pivot chart. FIELD A has 4 possible values: Value1, Value2, Valu3, UNKNOWN. I only want to show&nbsp; Value1, Value2, Valu3 in the pivot table when users click on FIELD A. Any idea how to do this? </P><P></P><P>Thanks in advance for the help.</P></BODY></HTML> Wed, 27 Feb 2013 17:36:53 GMT 2013-02-27T17:36:53Z Filtering values in dimension https://community.qlik.com/t5/QlikView/Filtering-values-in-dimension/m-p/390122#M145570 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a pivot table(chart) in which I am using a cyclic group to cycle through a few dimensions. Is there a way to only show certiain vales of a dimension? For example, let's say that the cyclic group has 3 dimensions FIELD A, FIELD B, FIELD C. Users can cycle through these 3 filds in the pivot chart. FIELD A has 4 possible values: Value1, Value2, Valu3, UNKNOWN. I only want to show&nbsp; Value1, Value2, Valu3 in the pivot table when users click on FIELD A. Any idea how to do this? </P><P></P><P>Thanks in advance for the help.</P></BODY></HTML> Wed, 27 Feb 2013 17:36:53 GMT https://community.qlik.com/t5/QlikView/Filtering-values-in-dimension/m-p/390122#M145570 2013-02-27T17:36:53Z Re: Filtering values in dimension https://community.qlik.com/t5/QlikView/Filtering-values-in-dimension/m-p/390123#M145571 <HTML><HEAD></HEAD><BODY><P>When you create (or edit) a group you can click the Add expression button and create a calculated dimension for the group: if([FIELD A]&lt;&gt;'UNKNOWN',[FIELD A]). Give the expression a label and check the option Suppress When Value Is Null for the Group (on the Dimensions tab).</P></BODY></HTML> Wed, 27 Feb 2013 17:43:43 GMT https://community.qlik.com/t5/QlikView/Filtering-values-in-dimension/m-p/390123#M145571 Gysbert_Wassenaar 2013-02-27T17:43:43Z