Inheriting default fields into a list box using an expression

[tinkerz1]

I still can't inherit when len<1 or isnull

=if(IsNull([Location L3]) OR Len([Issue - Location L3])<1,[Issue - Location L3],{[ABC]<[Location L3]=$::[Location L3]>})

[swuehl]

Neil,

not sure what you are trying to do here.

{[ABC]<[Location L3]=$::[Location L3]>}

looks like a set analysis expression to me, but this can only be used within aggregation functions.

[tinkerz1]

Inheriting default fields into a list box using an expression

My full discusion is here, if you can take a look its very appreciated

[swuehl]

Sorry, I don't really get what you want from this post, too.

Could you upload a small sample QVW?

[tinkerz1]

Sorry I am restricted by what I can upload.

So I will try to explain by the picture above. they are list boxes, the 2nd column on a list box is an expression for both Name list boxes

I have 1 named state and one inherited state, on the left <state 1> I select france and and all the countries go '-'

The expression is just 'Location' in the Name field.

What I want is to hold the countries as in the 'Inherited state', thats why I thought after the selection you need an expression to look and inherited and pull in the original data.

My second question is in both states blanks to not show up, my thoughts are in the loading script to fill out these blanks with a '-' so you can see there are blanks in the data, or does QV have a solution for this in the settings?

Thanks.

Neil.

[swuehl]

as expression in your list box, try

=only({1} Location)

or

=only({$} Location)

With regard to blanks (I think you are referring to NULL) are not showing up, I think that is default behaviour, NULL is not a value.

You can try changing that (search for NULLASVALUE), or just creating a dummy value while loading:

LOAD

     if(len(trim(Location)), Location, '--') as Location,

     if(len(trim(Name)), Name, '--') as Name,

     ...

FROM ...;