topic Re: Select data that contains certain dimension in QlikView https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256647#M397017 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm using a dimension called category. I sum the revenues of all categories, but all what I want is to see the total basket revenues from the orders that contains baby.</P><P></P><P>thank's</P></BODY></HTML> Fri, 24 Feb 2017 08:52:20 GMT ecabanas 2017-02-24T08:52:20Z Select data that contains certain dimension https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256642#M397012 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm creating a table calculating a gross marging for certain categories, but is it possible to calculate for example the orders that contain Baby category?</P><P></P><P>Thank's</P><P></P><P>Eduard</P></BODY></HTML> Thu, 23 Feb 2017 16:12:31 GMT https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256642#M397012 ecabanas 2017-02-23T16:12:31Z Re: Select data that contains certain dimension https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256643#M397013 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P><STRONG>sum({&lt;OrderCategory={"Baby"}&gt;}Sales)</STRONG></P></BODY></HTML> Thu, 23 Feb 2017 17:29:46 GMT https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256643#M397013 aarkay29 2017-02-23T17:29:46Z Re: Select data that contains certain dimension https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256644#M397014 <HTML><HEAD></HEAD><BODY><P>Hi Aar,</P><P></P><P>Thank's for your answer, but not it is..your formula is the sum of sales for the category Baby, I have 10 categories.</P><P></P><P>I want to calculate the total of the basquet for the people who bought something from baby category</P><P></P><P>Best </P><P></P><P>Eduard</P></BODY></HTML> Thu, 23 Feb 2017 17:32:44 GMT https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256644#M397014 ecabanas 2017-02-23T17:32:44Z Re: Select data that contains certain dimension https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256645#M397015 <HTML><HEAD></HEAD><BODY><P>I am not clear on what exactly you want </P><P>can you please explain with sample data</P></BODY></HTML> Thu, 23 Feb 2017 17:40:33 GMT https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256645#M397015 aarkay29 2017-02-23T17:40:33Z Re: Select data that contains certain dimension https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256646#M397016 <HTML><HEAD></HEAD><BODY><P>What are your dimensions and expressions you are using here?</P></BODY></HTML> Thu, 23 Feb 2017 18:06:10 GMT https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256646#M397016 vishsaggi 2017-02-23T18:06:10Z Re: Select data that contains certain dimension https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256647#M397017 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm using a dimension called category. I sum the revenues of all categories, but all what I want is to see the total basket revenues from the orders that contains baby.</P><P></P><P>thank's</P></BODY></HTML> Fri, 24 Feb 2017 08:52:20 GMT https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256647#M397017 ecabanas 2017-02-24T08:52:20Z Re: Select data that contains certain dimension https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256648#M397018 <HTML><HEAD></HEAD><BODY><P>I am not sure what you mean by Total Basket revenues? Can you share a sample app and expected output please?</P></BODY></HTML> Fri, 24 Feb 2017 13:38:39 GMT https://community.qlik.com/t5/QlikView/Select-data-that-contains-certain-dimension/m-p/1256648#M397018 vishsaggi 2017-02-24T13:38:39Z