Filtering Listbox Fields

[alwayslearning]

Hi,

I am new to Qlikview.

I am creating a list box to show '$Field', which is all the column names in my raw data.  There are a lot of columns but I only want a few to appear how can I select just the few I want to be visible and selectable on the listbox.

My ultimate goal is to create a table, where based on the condition that the user selects the Field from the list box it will then appear or now.  I have been able to do the Conditional show/hide part.

Regards,

Qlikview Novice

[sunny_talwar]

I think since sales price is two words, it needs square brackets around it. Can you check this:

=Avg({<ProductID = {$(=Chr(34) & '=' & Concat('Len(Trim([' & $Field & '])) = 0', ' or ') & Chr(34))}>} 1)

Test this out and see if its working or not and I will get back to explaining this sometime today evening.

[sunny_talwar]

Also look at this attached sample to look at all the nulls in each of your field.

[alwayslearning]

Thanks very much Sunny.  This has seemed to given me what I need.

[alwayslearning]

I decided to in my load scripts create nullversion of my columns i.e. if null =1 and then I summed them up in expressions to get total null values.

[ziabobaz]

Hi!

I tried your expression and it is not working as I want it to work.

I want to hide one of the Fields in the filter pane so the user won't see it.

I put the following formula:

Aggr(Only({<[Field]-={'Text'}>} [Field]), [Field])

It hides the Text field while no selection is made - it's good.

Once i make a selection of the other fields, it hides the rest of the fields  - that's bad.

Any idea?

[sunny_talwar]

Try this (moving the placement of minus sign after =:

Aggr(Only({<[Field] = -{'Text'}>} [Field]), [Field])

[ziabobaz]

Great!

Although I don't understand why.

"-=" is the common expression for NOT EQUAL

[sunny_talwar]

Slight difference

Field1 is composed of ABC, DEF, GHI and we have selected ABC & DEF

Field1 -= {'ABC'} means exclude ABC from Field1 based on selection

Will show DEF

Field1 = - {'ABC'} (is equivalent to Field1 = {'*'} - {'ABC'}) means no matter what the selection is

Will show DEF & GHI