Show field>How do i allow the listbox for a field to show selections?

[Anonymous]

Hi,

Please refer to the attached screenshot. How do I get my "Customer" listbox to show selections? The listboxes for my "Division Name" and "Region Name" fields show selections.

So I was wondering whether the "Customer" listbox has too many possible values/selections, therefore there is no way for Qlikview to list all "Customer" selections in the "Customer" listbox?

[sunny_talwar · Accepted solution]

I think the order your tabs in the script were off... since you are doing Where Exsits([Customer Number]) when you load your Customers table... you need to bring the Customer Number field from SalesData before you bring Customer table. Because if you don't, then Customer Number is not a field and Customer table will be completely blank.

I moved SalesData to load before Customer now

And see how Customer list box is now all populated

[Anonymous]

Hi Sunny,

Thank you so much for explaining your thought process. This is clearer now.

So generally any table using a common field to filter out results should have its tab demoted/loaded at a later stage.

I will keep this in mind when I import my data into Qlikview in future.