topic Re: Multiple Dimensions in QlikView https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419866#M1156639 <HTML><HEAD></HEAD><BODY><P>Hi, many thanks for your help. The raw data looks like: </P><P></P><P>number&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; criteria1&nbsp; criteria2</P><P>acnumber1&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>acnumber2&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>acnumber3&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>acnumber4&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; </P><P></P><P>what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.</P><P></P><P>My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; number of accounts</P><P>criteria1</P><P>criteria2</P><P></P><P></P><P>please let me know if this does not make sense.</P></BODY></HTML> Mon, 14 Jan 2013 13:03:13 GMT 2013-01-14T13:03:13Z Multiple Dimensions https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419864#M1156635 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I would like to add a table where I have 2 summary fields as expression (total value for example). In the dimension I want the top line to be Total and the second line to be the total where a certain criteria is met. What is the best way to achieve this?</P><P></P><P>For example</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum value</P><P>Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2500</P><P>with criteria 1800</P><P></P><P>many thanks</P></BODY></HTML> Mon, 14 Jan 2013 12:26:55 GMT https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419864#M1156635 2013-01-14T12:26:55Z Re: Multiple Dimensions https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419865#M1156637 <HTML><HEAD></HEAD><BODY><P>can you attached your sample file...</P><P>i didnot get you exactly</P></BODY></HTML> Mon, 14 Jan 2013 12:35:54 GMT https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419865#M1156637 er_mohit 2013-01-14T12:35:54Z Re: Multiple Dimensions https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419866#M1156639 <HTML><HEAD></HEAD><BODY><P>Hi, many thanks for your help. The raw data looks like: </P><P></P><P>number&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; criteria1&nbsp; criteria2</P><P>acnumber1&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>acnumber2&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>acnumber3&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>acnumber4&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; </P><P></P><P>what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.</P><P></P><P>My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; number of accounts</P><P>criteria1</P><P>criteria2</P><P></P><P></P><P>please let me know if this does not make sense.</P></BODY></HTML> Mon, 14 Jan 2013 13:03:13 GMT https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419866#M1156639 2013-01-14T13:03:13Z Re: Multiple Dimensions https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419867#M1156640 <HTML><HEAD></HEAD><BODY><P>Hi, many thanks for your help. The raw data looks like: </P><P></P><P>number&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; criteria1&nbsp; criteria2</P><P>acnumber1&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>acnumber2&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>acnumber3&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>acnumber4&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; </P><P></P><P>what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.</P><P></P><P>My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; number of accounts</P><P>criteria1</P><P>criteria2</P><P></P><P></P><P>please let me know if this does not make sense.</P></BODY></HTML> Mon, 14 Jan 2013 13:03:18 GMT https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419867#M1156640 2013-01-14T13:03:18Z Re: Multiple Dimensions https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419868#M1156641 <HTML><HEAD></HEAD><BODY><P>Would you accept, as result, the data (criteria1, criteria2, total) in diffent columns instead of rows?</P><P></P><P></P><P>Regards,</P><P>Daniele</P></BODY></HTML> Mon, 14 Jan 2013 15:16:47 GMT https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419868#M1156641 2013-01-14T15:16:47Z Re: Multiple Dimensions https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419869#M1156642 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I attached a solutions.</P><P></P><P>Regards!</P></BODY></HTML> Mon, 14 Jan 2013 15:27:28 GMT https://community.qlik.com/t5/QlikView/Multiple-Dimensions/m-p/419869#M1156642 2013-01-14T15:27:28Z