topic Re: Non associated values required in a new list box in QlikView

Non associated values required in a new list box

shmkmr90 — Wed, 21 Mar 2018 09:37:11 GMT

Hi,

My requirement is,

Scenario 1:

A dimension in list box is selected with some values, i want to view the non associated values of the same dimension in another listbox (for just view only purpose). is this possible?

for example, I have an year dimesnion with {2014,2015,2016,2017} values. when 2014 and 2015 are selected in list box A, there will be 2016,2017 greyed out. i want these values to be seen in a separate list box.

Scenario 2: If it cannot be possible in a new list box, can we have it in a textbox level concatenated or some other way?

Thanks,

Shyam

Re: Non associated values required in a new list box

jwjackso — Wed, 21 Mar 2018 11:20:36 GMT

If you use a text object,

=Concat({<Dim1=E(Dim1)>}Dim1,Chr(10))

Re: Non associated values required in a new list box

shmkmr90 — Wed, 21 Mar 2018 11:48:53 GMT

Thank you Jerry. It is working in a text box. Can't we have in a list box? Although it is for View only, List box seems a look good than a text box. isn't it ?

Re: Non associated values required in a new list box

jwjackso — Wed, 21 Mar 2018 13:48:45 GMT

I'm not sure about another list box, but you could use a straight table. In the expression: =if(Count({<Dim1=E(Dim1)>} Dim1) > 0,1,0)

Hide the expression column, suppress zero-values, no totals, no caption.

Re: Non associated values required in a new list box

shmkmr90 — Thu, 22 Mar 2018 05:10:20 GMT

Thank you Jerry. It looks great.