topic Straigth Table Calculated Dimension Condition on some Other Dimension in QlikView https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664633#M242016 <HTML><HEAD></HEAD><BODY><P>I have one calculated dimension which is a complex</P><P></P><P>IF(<SPAN style="font-size: 10pt; line-height: 1.5em;">match( pick(1+match(...,...,...,... </SPAN></P><P></P><P>Let's called this calculated field: Field1</P><P></P><P>I would like to have&nbsp; a second calculated dimension which is further filtering the Field1 : if the sum of Revenues for one value of Field1 is more than 10k, keep the value, else drop it.</P><P></P><P>How could I achieve so?</P><P></P><P>Many thanks in advance</P></BODY></HTML> Mon, 28 Jul 2014 14:00:29 GMT 2014-07-28T14:00:29Z Straigth Table Calculated Dimension Condition on some Other Dimension https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664633#M242016 <HTML><HEAD></HEAD><BODY><P>I have one calculated dimension which is a complex</P><P></P><P>IF(<SPAN style="font-size: 10pt; line-height: 1.5em;">match( pick(1+match(...,...,...,... </SPAN></P><P></P><P>Let's called this calculated field: Field1</P><P></P><P>I would like to have&nbsp; a second calculated dimension which is further filtering the Field1 : if the sum of Revenues for one value of Field1 is more than 10k, keep the value, else drop it.</P><P></P><P>How could I achieve so?</P><P></P><P>Many thanks in advance</P></BODY></HTML> Mon, 28 Jul 2014 14:00:29 GMT https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664633#M242016 2014-07-28T14:00:29Z Re: Straigth Table Calculated Dimension Condition on some Other Dimension https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664634#M242017 <HTML><HEAD></HEAD><BODY><P>Create this field in the script and after that will be easy filter the revenues grater than 10k in charts</P></BODY></HTML> Mon, 28 Jul 2014 14:03:37 GMT https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664634#M242017 2014-07-28T14:03:37Z Re: Straigth Table Calculated Dimension Condition on some Other Dimension https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664635#M242018 <HTML><HEAD></HEAD><BODY><P>I cannot use the script but only the calculated dimension in a pivot or straight table. many thanks</P></BODY></HTML> Mon, 28 Jul 2014 14:04:49 GMT https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664635#M242018 2014-07-28T14:04:49Z Re: Straigth Table Calculated Dimension Condition on some Other Dimension https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664636#M242019 <HTML><HEAD></HEAD><BODY><P>If you use that kind of calculated dimension and create a new one base on other calculated dimension will affect a lot the performance of your document.</P></BODY></HTML> Mon, 28 Jul 2014 14:23:33 GMT https://community.qlik.com/t5/QlikView/Straigth-Table-Calculated-Dimension-Condition-on-some-Other/m-p/664636#M242019 2014-07-28T14:23:33Z