LOAD Excel Table in QlikView - when field is empty SELECT ALL
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.
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.
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.
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.
