Lists and behaviour

[#1]

I have another situation where I have two drop lists on a sheet.  On selecting an item from the first the standard behaviour for QlikView is to grey out items across the objects that are not in context. So this happens on the second drop list but what I want is the in the list which are not greyed out to appear at the top of the list.

[alexandros17]

What you ask is the normal behaviour, have you use expressions in the second list?

[jpenuliar]

You can try to change the Sort Property >> Sort by>> State >> Auto Ascending or Ascending.

This should put the White associations at the top list

[#4]

yeah the second list is based on an expression. 

[alexandros17]

That's the reason, if you can try to compute that expression in the script (as a new field) and use it in the list box...

[#6]

the challenge I have is the expression concatinates two fields from two different dimensions so how would I manage that in the script?

[#7]

Here is the expression i have in the list object: = If(not isnull(Specialty),LocalServiceLine & ': ' & Specialty)

and where I would expect it to be in the script is:

Hierarchy (LocalServiceLine, LocalServiceLineParent, LocalServiceLineDescription, , LocalServiceLineDescription,'\', 'HIEARACHY DEPTH')

LOAD LocalServiceLine,

  LocalServiceLineParent,

  LocalServiceLineDescription

  Resident DIMLocalServiceLine;

  Drop table DIMLocalServiceLine;

RENAME Fields LocalServiceLineDescription1  to Trust, LocalServiceLineDescription2 to Division, LocalServiceLineDescription3 to Specialty;

Please can you help

[#8]

the challenge I have is the expression concatinates two fields from two different dimensions so how would I manage that in the script?

[#9]

Here is the expression i have in the list object: = If(not isnull(Specialty),LocalServiceLine & ': ' & Specialty)

and where I would expect it to be in the script is:

Hierarchy (LocalServiceLine, LocalServiceLineParent, LocalServiceLineDescription, , LocalServiceLineDescription,'\', 'HIEARACHY DEPTH')

LOAD LocalServiceLine,

  LocalServiceLineParent,

  LocalServiceLineDescription

  Resident DIMLocalServiceLine;

  Drop table DIMLocalServiceLine;

RENAME Fields LocalServiceLineDescription1  to Trust, LocalServiceLineDescription2 to Division, LocalServiceLineDescription3 to Specialty;

Please can you help