Basic Problem: We want to be able to import, for example, a bunch of otherwise unrelated item numbers into our Sales cubes and have them become selected based on what's in the imported file.(online, non via load)
1 Method
I know I could do it by selecting a bunch of item numbers, and then exporting a bookmark.
I could then reimport that bookmark and the selections will be made
But, I'd like to edit that list outside of Qlikview, thereby making a custom selection list and then import that back in.
Unfortunately, The bookmark files are not easily human readable, especially the values.
En a Excel create a table with 1 column containing field names and 1 column with a list of values. In your script do a binary load of the QV file and import the excel using a loop that assigns the list of values from one column to a variable that corresponds with the field name. Something like the script below:
Binary QVFile.qvw;
Expresiones: LOAD Variable, Expresion FROM Expresiones.xlsx (ooxml, embedded labels, table is Sheet1);
Let vNroRegistros = NoOfRows('Expresiones');
For vI = 0 to (vNroRegistros - 1)
Let vNombre_Variable = Peek('Variable',vI,'Expresiones');
Let [$(vNombre_Variable)] = Peek('Expresion',vI,'Expresiones');
Next
Then make an action to select in the corresponding fields of each variable.
If you need more then one group of selections then add another column to the excel which you can use to identify which group of selections to run the action on. The user would have to select the selection group first and then click the button that runs the action to make the selections.
I hope that helps you think of the exact solution you need.
