topic Re: Subfields not showing all values in listbox in QlikView

Subfields not showing all values in listbox

Thu, 03 Jul 2014 13:00:39 GMT

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

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

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.

Re: Subfields not showing all values in listbox

MK_QSL — Thu, 03 Jul 2014 13:12:00 GMT

Kindly provide some sample data...of MsgCategories

Re: Subfields not showing all values in listbox

mahesh_agrawal — Thu, 03 Jul 2014 13:12:10 GMT

Hi,

Could you share your application?

It would be easy to analyze the issue.

Re: Subfields not showing all values in listbox

rwunderlich — Thu, 03 Jul 2014 13:16:57 GMT

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

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

-Rob

Re: Subfields not showing all values in listbox

PradeepReddy — Thu, 03 Jul 2014 13:22:47 GMT

Try..

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

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

Re: Subfields not showing all values in listbox

Thu, 03 Jul 2014 13:43:12 GMT

Here it is ,

Re: Subfields not showing all values in listbox

Thu, 03 Jul 2014 13:45:47 GMT

It's in there but same problem

Re: Re: Subfields not showing all values in listbox

PradeepReddy — Thu, 03 Jul 2014 13:56:30 GMT

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

MK_QSL — Thu, 03 Jul 2014 14:05:38 GMT

use this...

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

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

Re: Subfields not showing all values in listbox

Thu, 03 Jul 2014 14:10:25 GMT

Tried your suggestions still same thing

Re: Subfields not showing all values in listbox

Thu, 03 Jul 2014 14:15:21 GMT

O man the data is there, it is just that Qlikview has the numbers on the right side if I go to presentation and change it to left, IT shows everything. wow!