Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Drop down list of table names

Hi,

I am working with a set of data including a transaction file and several balance files at various dates.  The objective is to do a standard opening + transactions = closing reconciliation.

In order to make it more dynamic, I am seeking to make two drop downs so the user can select the opening and closing balance tables to pull the data from, but I cannot find any expression that allows me to list the available tables in the document as constraints for a dropdown box.

I thought the hard bit would be filtering the transactions by an arbitrary date range, but it appears that that is the easy part (btw, http://community.qlik.com/qlikviews/1075 is a highly recommended introduction to date ranges)

For background, the data structure includes the following files:

Transactions - listing of all transactions

20100101 - balance file

20100708 - balance file

20110503 - balance file

... [any future balance files in YYYYMMDD format]

On import, all fields except the primary key are qualified for uniqueness and all balance files are have standard structure

Has anyone come across this before, and know of any way to list the available tables?

Thanks

Tim

1 Solution

Accepted Solutions
MVP
MVP

Re: Drop down list of table names

Hi

You are using an unconentional approach. Normally you would load all the balances into a single table and use the date to select the balances to use in an expression. What you are trying makes this quite a lot more complicated.

I would suggest that you consider adapting you model in this way. But if that is not possible, or you have other reasons for using your approach, to get the list of tables, you can use the $Table system field.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: Drop down list of table names

Hi

You are using an unconentional approach. Normally you would load all the balances into a single table and use the date to select the balances to use in an expression. What you are trying makes this quite a lot more complicated.

I would suggest that you consider adapting you model in this way. But if that is not possible, or you have other reasons for using your approach, to get the list of tables, you can use the $Table system field.

Hope that helps

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Drop down list of table names

Thank you for both of your answers, you have a good point about the data model

Community Browser