Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Select Tables from within Qlikview

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

2014-03-13_1635.png

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

7 Replies
marcus_malinow
Specialist III
Specialist III


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

rustyfishbones
Master II
Master II
Author

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

2014-03-13_1650.png

Not applicable

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

rustyfishbones
Master II
Master II
Author

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

2014-03-13_1641.png

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

like

2014-03-13_1641_001.png

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

Sorry just wanted to be clear

Thanks

Alan

marcus_malinow
Specialist III
Specialist III

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...

Not applicable

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

and in the script: $(Thisvar)

Fabrice

Not applicable

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