Custom Selection

Tue, 21 Dec 2010 23:04:18 GMT

Hello, I'd appreciate any help

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.

AND, I want end users to be able to do it.

Thanks Again!

Custom Selection

pover — Wed, 22 Dec 2010 01:25:29 GMT

Here's an idea...

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.

Regards.

topic Custom Selection in QlikView

Custom Selection

Custom Selection