topic How to take only some values from created dimentions table in QlikView https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710525#M255967 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; Friends,</P><P></P><P>I have created a Dimentions table while loading tables.</P><P> Dimentions:</P><P>Commisions</P><P>Premiums;</P><P></P><P>Now I want to add only one of these dimentions into pivot table.</P><P></P><P>When add Dimentions its taking both Commisions and Premiums into the table Dimentions</P><P></P><P>Thanks</P><P>pavan</P></BODY></HTML> Thu, 04 Sep 2014 12:35:30 GMT 2014-09-04T12:35:30Z How to take only some values from created dimentions table https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710525#M255967 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp; Friends,</P><P></P><P>I have created a Dimentions table while loading tables.</P><P> Dimentions:</P><P>Commisions</P><P>Premiums;</P><P></P><P>Now I want to add only one of these dimentions into pivot table.</P><P></P><P>When add Dimentions its taking both Commisions and Premiums into the table Dimentions</P><P></P><P>Thanks</P><P>pavan</P></BODY></HTML> Thu, 04 Sep 2014 12:35:30 GMT https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710525#M255967 2014-09-04T12:35:30Z Re: How to take only some values from created dimentions table https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710526#M255968 <HTML><HEAD></HEAD><BODY><P>Utiliza IF()</P></BODY></HTML> Thu, 04 Sep 2014 12:39:54 GMT https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710526#M255968 walterlh 2014-09-04T12:39:54Z Re: How to take only some values from created dimentions table https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710527#M255969 <HTML><HEAD></HEAD><BODY><P>Try calculated dimension. Expression like: =if(Dimension='Commisions', Dimension) , then in the same tab check 'Supress Values When Null'.</P></BODY></HTML> Thu, 04 Sep 2014 12:40:08 GMT https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710527#M255969 tresB 2014-09-04T12:40:08Z Re: How to take only some values from created dimentions table https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710528#M255970 <HTML><HEAD></HEAD><BODY><P>Como se llama tu campo? donde guardas "<SPAN style="font-family: inherit; font-style: inherit; font-weight: inherit; color: #3d3d3d; font-size: 10pt; line-height: 1.5em;">Comisiones y </SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit;"><SPAN class="goog-text-highlight" style="font-weight: inherit; font-style: inherit; font-family: inherit; background-color: #c9d7f1;">Las primas"... </SPAN></SPAN></P></BODY></HTML> Thu, 04 Sep 2014 12:41:16 GMT https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710528#M255970 walterlh 2014-09-04T12:41:16Z Re: How to take only some values from created dimentions table https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710529#M255971 <HTML><HEAD></HEAD><BODY><P>i didn't get you . can you send us an exemple or may be an app?</P></BODY></HTML> Thu, 04 Sep 2014 12:42:03 GMT https://community.qlik.com/t5/QlikView/How-to-take-only-some-values-from-created-dimentions-table/m-p/710529#M255971 mohamed_ahid 2014-09-04T12:42:03Z