topic Re: Select Tables from within Qlikview in QlikView

Select Tables from within Qlikview

rustyfishbones — Thu, 13 Mar 2014 16:39:32 GMT

Hi All,

I want to create a simple Extract file where I can click Yes or No to load a specific table.

So if I have 3 tables called ardclass, asnheadlog, asnlinelog

I want to be able to click yes or no if I want to load those tables but from within a Qlikview file

Something like

Does anyone have a simple example of this?

I have the Script for each table in a sub routine, and I can CALL the Sub Routine from the Script Editor

I want to tick a box in the Qlikview front end that will select the tables I want to extract

Re: Select Tables from within Qlikview

marcus_malinow — Thu, 13 Mar 2014 16:47:36 GMT

Hi Alan,

no example to hand, but I've done similar with InputBoxes being used to set variables. Then, in your script check the value of the variable before loading the tables.

Marcus

Re: Select Tables from within Qlikview

rustyfishbones — Thu, 13 Mar 2014 16:53:35 GMT

Hi Marcus,

I have done this already with one table, thanks, but would that mean I would need a separate variable for each table?

I was hoping to have a Qlikview Extraction file where I could simply Extract the Tables I need by selecting them from a list box like below

Re: Select Tables from within Qlikview

Thu, 13 Mar 2014 16:56:08 GMT

Alan,

I have made successfull test where

- I populated some variables in the UI (InputBox or variables with = sign)

- I had a button to run the reload

- the script tested the variable(s)

In your case, perhaps a simple data island (a single table) that the user selects, a variable = to what is selected

that's it

Fabrice

Re: Select Tables from within Qlikview

rustyfishbones — Thu, 13 Mar 2014 16:56:51 GMT

I have an include file with all Tables in Sub Routines at the moment

Then in my script editor I uncomment the table I want to CALL from the Sub Routine

I would like to to do this in the front end by ticking a box.

Sorry just wanted to be clear

Thanks

Alan

Re: Select Tables from within Qlikview

marcus_malinow — Thu, 13 Mar 2014 17:03:10 GMT

ok so maybe set up a trigger to populate your single variable on selection of your Tables Field. Set it to:

':' & GetSelectedValues(Tables,':',1000) & ':'

Then in your script on each table load check for

index(Variable, tablename)

or similar...

Re: Select Tables from within Qlikview

Fri, 14 Mar 2014 08:01:06 GMT

Create a variable that will be equal to null() or 'Call prodsevesocat' according to your selection,

and in the script: $(Thisvar)

Fabrice

Re: Select Tables from within Qlikview

Sat, 15 Mar 2014 02:28:48 GMT

I tested with List box & variables. The calculated variables are not working in the script.