Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
tinkerz1
Contributor II

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

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

5 Replies
MVP
MVP

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

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
Contributor II

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

Inheriting default fields into a list box using an expression

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

MVP
MVP

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

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

Could you upload a small sample QVW?

tinkerz1
Contributor II

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

Location.PNG
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.

MVP
MVP

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

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

Community Browser