topic Re: Inheriting default fields into a list box using an expression in QlikView

Re: Inheriting default fields into a list box using an expression

tinkerz1 — Wed, 24 Jun 2015 14:58:33 GMT

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]>})

Re: Inheriting default fields into a list box using an expression

swuehl — Thu, 25 Jun 2015 12:42:10 GMT

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.

Re: Inheriting default fields into a list box using an expression

tinkerz1 — Thu, 25 Jun 2015 13:00:15 GMT

Inheriting default fields into a list box using an expression

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

Re: Inheriting default fields into a list box using an expression

swuehl — Thu, 25 Jun 2015 13:10:31 GMT

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

Could you upload a small sample QVW?

Re: Inheriting default fields into a list box using an expression

tinkerz1 — Thu, 25 Jun 2015 13:38:24 GMT

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.

Re: Inheriting default fields into a list box using an expression

swuehl — Thu, 25 Jun 2015 14:03:24 GMT

as expression in your list box, try

=only({1} Location)

=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 ...;