topic LOAD Excel Table in QlikView - when field is empty SELECT ALL in QlikView

LOAD Excel Table in QlikView - when field is empty SELECT ALL

Wed, 16 Jun 2010 06:59:21 GMT

Hi,

I loaded an Excel File in QlikView via Script. Now many columns are connected with other columns.

e.g. Table Loaded in Document named "COST CENTER" - in QliKView there also exists an table named "COST CENTER".
Now I select the field 45510 from my loaded table and QlikView now is showing only data to the COST LOCATION 45510.
But theres another field in the loaded "COST CENTER" table, thats empty. When I'm selecting this, QlikView shows no data at all.
I want to know, how it is possible, that when I select a field from my loaded Excel table, thats empty, QlikView shows me all data from all Cost Center Locations.

Thanks for help in this case.

LOAD Excel Table in QlikView - when field is empty SELECT ALL

Wed, 16 Jun 2010 10:11:47 GMT

Any ideas?

LOAD Excel Table in QlikView - when field is empty SELECT ALL

sparur — Wed, 16 Jun 2010 10:57:29 GMT

can you post a small example (qvw) with your problem

LOAD Excel Table in QlikView - when field is empty SELECT ALL

Wed, 16 Jun 2010 11:28:19 GMT

Hi ,

can u sepcify it clearly and post the sample qvw ???

LOAD Excel Table in QlikView - when field is empty SELECT ALL

Wed, 16 Jun 2010 11:49:42 GMT

Ok, I've attached a QVForum.zip.

It contains the QVForum.qvw. In this .qvw I loaded two excel tables.
When I'm selecting "tro\Test1", QlikView reduce the data only to User1.
But when selecting "tro\Test4", which has no value in COST CENTER, QlikView shows nothing.
I want, that QlikView show all data, when selecting "tro\Test4" or a field where the COST CENTER column is empty.

How can I achieve this.

Thanks in advance!

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0842.QVForum.zip:550:0]

LOAD Excel Table in QlikView - when field is empty SELECT ALL

Thu, 17 Jun 2010 07:27:52 GMT

Any ideas?

AW:LOAD Excel Table in QlikView - when field is empty SELECT ALL

biester — Thu, 17 Jun 2010 08:41:55 GMT

As far as I understand you want the following:
If you select a user whose cost center is 30, cost center 30 should be (and is) showing.
If you select a user who has no cost center, all cost centers should be showing.
That would come to an equation like: NO cost center = ALL cost centers. Actually I think this is not possible in a straight way and it seems to me contradictory to the concept of QlikView.

Any way, to make the mentioned equation true, you would need a sort of "mapping" table in between. Look at my example. I don't think you can achieve this in a more straight way.

Rgds,
Joachim

AW:LOAD Excel Table in QlikView - when field is empty SELECT ALL

Thu, 17 Jun 2010 09:38:42 GMT

Thank you very much, it's working now!