topic Manually select dimension values based on excel input in QlikView https://community.qlik.com/t5/QlikView/Manually-select-dimension-values-based-on-excel-input/m-p/760808#M1042069 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have a situation where we want to use information from an excel file and use this information as a selection of dimension values.</P><P></P><P>The excel files is updated by other people and I get this every other day. The files contains categories of items which we sell of which they want to get sales and additional information. (so I know there are other better way to do this but..)</P><P></P><P>What I would like to do is something like:</P><P>1. Transpose all category ids (matching the dimension in QV) in to one row in excel</P><P>2. Comma separate the IDs</P><P>3. Copy this long text string</P><P>4. Paste into the search input of the dimension and Boom the correct categories are selected and my report updated accordingly</P><P></P><P>Is there a way to accomplish this (ajax web)</P><P></P><P>Thanks,</P><P>Erik</P></BODY></HTML> Tue, 02 Dec 2014 15:21:26 GMT 2014-12-02T15:21:26Z Manually select dimension values based on excel input https://community.qlik.com/t5/QlikView/Manually-select-dimension-values-based-on-excel-input/m-p/760808#M1042069 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have a situation where we want to use information from an excel file and use this information as a selection of dimension values.</P><P></P><P>The excel files is updated by other people and I get this every other day. The files contains categories of items which we sell of which they want to get sales and additional information. (so I know there are other better way to do this but..)</P><P></P><P>What I would like to do is something like:</P><P>1. Transpose all category ids (matching the dimension in QV) in to one row in excel</P><P>2. Comma separate the IDs</P><P>3. Copy this long text string</P><P>4. Paste into the search input of the dimension and Boom the correct categories are selected and my report updated accordingly</P><P></P><P>Is there a way to accomplish this (ajax web)</P><P></P><P>Thanks,</P><P>Erik</P></BODY></HTML> Tue, 02 Dec 2014 15:21:26 GMT https://community.qlik.com/t5/QlikView/Manually-select-dimension-values-based-on-excel-input/m-p/760808#M1042069 2014-12-02T15:21:26Z