topic Separate Product Columns in QlikView https://community.qlik.com/t5/QlikView/Separate-Product-Columns/m-p/301725#M1183324 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a number of products, split across different columns which I need to work with. I have attached a sample file of the data that I am working with.</P><P></P><P>What I would like to do is create a List Box (or similar) with Products A, B, C, D as options.</P><P>So far all I have been able to do is get a List Box with a single product and the options within the box are the various prices.</P><P></P><P>On selection, the ideal behaviour would be to look for the presence of a value in the particular column (as this would indicate that there was a sale) and then all other values would be filtered accordingly. It should be possible to select multiple values.</P><P>I think this may involve some kind of 'CountIf' type expression.</P><P></P><P>I hope this makes sense. I have a feeling that this is easy-ish but after a number of trials I am no closer!</P><P></P><P>Many thanks in advance.</P><P></P><P>Al</P></BODY></HTML> Wed, 14 Dec 2011 20:51:25 GMT 2011-12-14T20:51:25Z Separate Product Columns https://community.qlik.com/t5/QlikView/Separate-Product-Columns/m-p/301725#M1183324 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a number of products, split across different columns which I need to work with. I have attached a sample file of the data that I am working with.</P><P></P><P>What I would like to do is create a List Box (or similar) with Products A, B, C, D as options.</P><P>So far all I have been able to do is get a List Box with a single product and the options within the box are the various prices.</P><P></P><P>On selection, the ideal behaviour would be to look for the presence of a value in the particular column (as this would indicate that there was a sale) and then all other values would be filtered accordingly. It should be possible to select multiple values.</P><P>I think this may involve some kind of 'CountIf' type expression.</P><P></P><P>I hope this makes sense. I have a feeling that this is easy-ish but after a number of trials I am no closer!</P><P></P><P>Many thanks in advance.</P><P></P><P>Al</P></BODY></HTML> Wed, 14 Dec 2011 20:51:25 GMT https://community.qlik.com/t5/QlikView/Separate-Product-Columns/m-p/301725#M1183324 2011-12-14T20:51:25Z