topic Re: Lists and behaviour in QlikView

Lists and behaviour

Tue, 27 Jan 2015 11:29:42 GMT

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.

Re: Lists and behaviour

alexandros17 — Tue, 27 Jan 2015 11:35:08 GMT

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

Re: Lists and behaviour

jpenuliar — Tue, 27 Jan 2015 11:35:13 GMT

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

Re: Lists and behaviour

Tue, 27 Jan 2015 11:52:46 GMT

yeah the second list is based on an expression.

Re: Lists and behaviour

alexandros17 — Tue, 27 Jan 2015 12:56:29 GMT

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

Re: Lists and behaviour

Thu, 29 Jan 2015 08:38:06 GMT

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

Re: Lists and behaviour

Thu, 29 Jan 2015 08:57:59 GMT

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

Re: Lists and behaviour

Thu, 29 Jan 2015 15:37:34 GMT

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

Re: Lists and behaviour

Thu, 29 Jan 2015 15:37:50 GMT

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