Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Subfields not showing all values in listbox

I am creating a subfields off of MsgCategories and I am having an issue where the Fields I believe hold the correct information, however they are not showing it in The Listbox, In Category1a there are Fields that hold values but do not show up in listboxes, but when I select them they are shown with the correct selected data in the current selections box and table box but not in the list box MsgCategories Help2.gif

My Second Isssue is that MsgCategories is doing the same thing but for fields that carry numbers in the beginning and only contain one fieldMsgCategories Help3.gif

I am trying to show all data , and split them by delimiter ;  . I am using    MsgCategories,     SUBFIELD(MsgCategories, ';') AS Category1a,     SUBFIELD(MsgCategories, ';', 2) AS Category1b, As my Script , Is there something wrong? Thank You.

Tags (3)
1 Solution

Accepted Solutions

Re: Subfields not showing all values in listbox

It looks like you may be missing the "1" in

SUBFIELD(MsgCategories, ';', 1) AS Category1a,


-Rob

10 Replies

Re: Subfields not showing all values in listbox

Kindly provide some sample data...of MsgCategories

mahesh_agrawal
Contributor

Re: Subfields not showing all values in listbox

Hi,

Could you share your application?

It would be easy to analyze the issue.

Re: Subfields not showing all values in listbox

It looks like you may be missing the "1" in

SUBFIELD(MsgCategories, ';', 1) AS Category1a,


-Rob

pradeepreddy
Valued Contributor II

Re: Subfields not showing all values in listbox

Try..

SUBFIELD(MsgCategories, ';', 1) AS Category1a,

SUBFIELD(MsgCategories, ';', 2) AS Category1b

Not applicable

Re: Subfields not showing all values in listbox

Here it is ,

Not applicable

Re: Subfields not showing all values in listbox

It's in there but same problem

pradeepreddy
Valued Contributor II

Re: Re: Subfields not showing all values in listbox

If the ';' is not found it is treating as Category1a, otherwise it is splitting into 2 fields...(Category1a, Category1a)

I have done some changes in List box itself... PFA

Re: Subfields not showing all values in listbox

use this...

IF(Index(MsgCategories,';')>0,SubField(MsgCategories,';',1),MsgCategories) as Category1a,

IF(INDEX(MsgCategories,';')>0,SubField(MsgCategories,';',2),'') as Category1b,

Not applicable

Re: Subfields not showing all values in listbox

Tried your suggestions still same thing

Community Browser