Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jblomqvist
Contributor II

Hello friends, How can I control which columns are loaded for a QlikView table from a file based on user input?

Hi all,

I am trying to control which columns are loaded for a QlikView table created from a file where the user controls which column to load.

For example in a Excel spreadsheet you might have the following columns:

OrderID,

OrderDate,

CustomerID,

ProductID,

SpecialNotes,

SalesValue

I would like to load the above table into QlikView, however it is up to the user which column is actually loaded.

So in a normal load it might look like:

Orders:

LOAD

OrderID,

OrderDate,

CustomerID,

ProductID,

SpecialNotes,

SalesValue

From

<excel file>

But what I want to do is control which column is shown in the Orders table.

So for example, they want to load all the columns above except ProductID, and SpecialNotes. And maybe another time they might choose to remove SalesValue field only and keep all the others

Anyone got any ideas how I can do this in QlikView please?

2 Replies
MVP
MVP

Re: Hello friends, How can I control which columns are loaded for a QlikView table from a file based on user input?

One way to do it would be to load the field names into QlikView and allow people to select what they want to load. Then, you can build the list of fields for your LOAD statement in a variable and use the variable in the script.

You may have to use Partial load, or apply other tricks to avoid losing your selected values at the beginning of the reload process. Or, you could have two documents - one document with the metadata (field names) and the other document that actually loads data into QlikView.

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Austin, TX and Johannesburg, South Africa!

Highlighted

Re: Hello friends, How can I control which columns are loaded for a QlikView table from a file based on user input?

I don't think there has to be an option for your users to influence the load execution only to let them decide "which column is shown in the Orders table".

There are many exmaples in this community to do so without reloading:

Customizable Straight Table

Customizable Straight Table

Advanced Data Discovery solution

Customisable Straight (and Pivot) Tables - more food for thought

hope this helps

regards

Marco