topic Complicated Filtering Criteria From Excel in QlikView

Complicated Filtering Criteria From Excel

Anonymous — Thu, 11 Feb 2010 13:22:10 GMT

Hi everybody,

I have a good challenge for you 🙂

I've searched this forum but with no result (may be wrong key words used). That's why - the new post.

Situation: There is a main table in external source. In Excel spreadsheet users can specify what kind of values they need to filter from main table. It is very simple if there is a need to specify values of one field in main table. But what if needs are more complicated, e.g. user can specify not only accounts, but also several document types to filter.

In attached example we need to filter from main table transactions with accounts mentioned and with document types, separated by comma (empty cell means all types). I prefer, that subfield function will be used here.

Obligatory conditions:

Filtering must be made in script while reloading.
We can't download whole main table, 'cause it is huge, that's why manipulations with WHERE statement are needed

Any ideas?

Rds,
Artjoms

Complicated Filtering Criteria From Excel

Anonymous — Thu, 11 Feb 2010 14:55:08 GMT

After thinking a while I found one of many ways, how to make my dream come true.

May be somebody can propose more optimal solution?

Rds,
Artjoms

Complicated Filtering Criteria From Excel

Anonymous — Thu, 11 Feb 2010 18:30:11 GMT

Any other suggestions are still welcome!

Complicated Filtering Criteria From Excel

Anonymous — Thu, 18 Feb 2010 09:25:23 GMT

People use to say - nobody can help you better and quicklier than your oneself

I found two solutions for my case. Version with generating WHERE statement works faster with big data sources

Rgd,
AT