topic Re: Blank Data Fields in QlikView

Blank Data Fields

evansabres — Fri, 02 Jan 2015 15:56:03 GMT

Hello -

I have a data set that looks similar to this :

STH ID Name

114412423 John Smith

Dave Roberts

134514335 Joe Davis

Richard Smhelik

124541355 Maxim Tsyplakov

123413413 Robert Afinogenov

I am trying to create a list box that lists only the fields from STH ID that have a value?

How can I do this.

Thank you/

Re: Blank Data Fields

Fri, 02 Jan 2015 16:10:29 GMT

Hi Evan,

create a listbox as an expression rather than a field with the following

If(isnum([STH ID]), Name)

should give the desired output

hope that helps

Joe

Re: Blank Data Fields

Fri, 02 Jan 2015 16:16:13 GMT

See attached if that helps

Re: Blank Data Fields

evansabres — Fri, 02 Jan 2015 16:17:07 GMT

This makes the list box have both the STH id and the name, still returnig the fields that are blank.

My data table has 11,208 records, and rougly 1700 of them have STH ID....I want the list box to have only customers that have STH id

Re: Blank Data Fields

engishfaque — Fri, 02 Jan 2015 16:18:32 GMT

Dear Evan,

Kindly find attached document.

Kind regards,

Ishfaque Ahmed

Re: Blank Data Fields

Fri, 02 Jan 2015 16:22:01 GMT

Please see the attachment above , the listbox gives you the 4 names that have an ID only, which I think is what you are after?

Unless I have misunderstood

Joe

Re: Blank Data Fields

evansabres — Fri, 02 Jan 2015 16:33:32 GMT

Yes and No....My end goal is to create a button to allow the end user to 'Select All STH'....right now when you click the button, the action returns all fields under the heading STH_ID, including the blank fields.....my list box doesn't necessairly need to have the names of the STH, I just want to not include the blank fields....Again, I have 11,300 records, of which roughly 1800 have STH id's....is there an expression I can use within the list box to not return blank values?

Thanks so much for your help

Re: Blank Data Fields

Fri, 02 Jan 2015 17:05:27 GMT

Not sure I totally understand what you mean, but if you are looking for a button to select just those with numbers, the attached might help.

Failing that, I can't see how the expression I said wouldn't give you the result in the listbox you are after.

Maybe if you could knock up an example (or adjust mine a bit), it would be easier to understand you end requirement

thanks

Joe

Re: Blank Data Fields

evansabres — Fri, 02 Jan 2015 18:03:40 GMT

This was what I was looking for.

Thank you!

Re: Blank Data Fields

Mon, 05 Jan 2015 09:12:10 GMT

No problem. I should say you do have the option of adjusting those blanks to be nulls instead, which would make them drop from the listbox as default, nulls are not selectable.

I have found having nulls as actual values better though, as you may want the reverse of that question, which Names do not have an [STD ID], which is much easier to analyse when you have a selectable value instead of a null.

Just food for thought really

hope that helps

Joe