topic Need a Chart that shows Multiples in QlikView https://community.qlik.com/t5/QlikView/Need-a-Chart-that-shows-Multiples/m-p/519955#M194312 <HTML><HEAD></HEAD><BODY><P>I have a table with four columns: A, B, C, and D. I'd like to build a table that enables analysis on multiple occurrences of data in these columns. For example, if there are multiple instances of data in columns A, B and C, I'd like to see those, and a count, in my table. That's easy enough, but the analysis may call for the ability to find multiples on A,B,D; A,C,D; or A,B,C,D. (A will be held constant for now.) What I want to avoid is making four different charts.</P><P></P><P>The attached QlikView illustrates. It has a straight table that shows multiple occurrences on columns A, B, C and D. I'm looking for a way to make it more flexible as described -- i.e. the ability to exclude one of the columns in the analysis on multiples.</P><P></P><P>Appreciate any help. Thanks.</P></BODY></HTML> Wed, 13 Nov 2013 16:34:52 GMT 2013-11-13T16:34:52Z Need a Chart that shows Multiples https://community.qlik.com/t5/QlikView/Need-a-Chart-that-shows-Multiples/m-p/519955#M194312 <HTML><HEAD></HEAD><BODY><P>I have a table with four columns: A, B, C, and D. I'd like to build a table that enables analysis on multiple occurrences of data in these columns. For example, if there are multiple instances of data in columns A, B and C, I'd like to see those, and a count, in my table. That's easy enough, but the analysis may call for the ability to find multiples on A,B,D; A,C,D; or A,B,C,D. (A will be held constant for now.) What I want to avoid is making four different charts.</P><P></P><P>The attached QlikView illustrates. It has a straight table that shows multiple occurrences on columns A, B, C and D. I'm looking for a way to make it more flexible as described -- i.e. the ability to exclude one of the columns in the analysis on multiples.</P><P></P><P>Appreciate any help. Thanks.</P></BODY></HTML> Wed, 13 Nov 2013 16:34:52 GMT https://community.qlik.com/t5/QlikView/Need-a-Chart-that-shows-Multiples/m-p/519955#M194312 2013-11-13T16:34:52Z Re: Need a Chart that shows Multiples https://community.qlik.com/t5/QlikView/Need-a-Chart-that-shows-Multiples/m-p/519956#M194313 <HTML><HEAD></HEAD><BODY><P>If you're using QV11 you can use conditional display expressions. See attached qvw.</P></BODY></HTML> Wed, 13 Nov 2013 17:53:14 GMT https://community.qlik.com/t5/QlikView/Need-a-Chart-that-shows-Multiples/m-p/519956#M194313 Gysbert_Wassenaar 2013-11-13T17:53:14Z Re: Need a Chart that shows Multiples https://community.qlik.com/t5/QlikView/Need-a-Chart-that-shows-Multiples/m-p/519957#M194314 <HTML><HEAD></HEAD><BODY><P>That's perfect. It would have been a while before I stumbled over that (conditional display). Thanks so much! </P></BODY></HTML> Wed, 13 Nov 2013 18:47:40 GMT https://community.qlik.com/t5/QlikView/Need-a-Chart-that-shows-Multiples/m-p/519957#M194314 2013-11-13T18:47:40Z