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?

[techvarun]

Share some sample data or App. If the field customer has relative data then it is a normal qlikview behavior to show all the possible values

[Anonymous]

Hi techvarun,

Please refer to the "Customer" column in the file "M2_Customers.xls"

[Anonymous]

This is how the "Customer" listbox should look like, but I can't seem to get to this stage.

I was wondering whether there is a setting in 'Properties' or in the 'Script' that I have to update.

[sunny_talwar]

Are you using an expression to display customers? or is it straight field that you use?

[Anonymous]

Hi stalwar1,

I am using a straight field from the "Customer" column in the spreadsheet.

The script is as follows:

Customers:

LOAD [Address Number],

     [Business Family],

     [Business Unit],

     Customer,

     [Customer Number],

     [Customer Type],

     Division,

     [Line of Business],

     [Phone],

     [Region Code],

     [Regional Sales Mgr],

     [Search Type]

FROM

M2_Customers.xls

(biff, embedded labels, table is CUSTOMERS$) Where exists ([Customer Number]);

[sunny_talwar]

Straight table? Can you try to uncheck 'Suppress Zero Values' on the presentation tab and see if that works?

[Anonymous]

Hi Sunny,

I can't seem to find the 'Suppress Zero Values' option.

And when I looked at my dataset, there are no zero values in both [Customer] and [Customer Number].

[sunny_talwar]

This is list box... but you mentioned straight table.... I am not sure what's wrong... can you share a sample?

[Anonymous]

Hi Sunny,

Sorry for mixing up list box and straight table. Mm maybe I can upload my Qlikview file and the data set I am using for my training to let you have a look?