Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shmkmr90
Contributor III
Contributor III

Non associated values required in a new list box

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

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

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.

View solution in original post

4 Replies
jwjackso
Specialist III
Specialist III

If you use a text object,

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

shmkmr90
Contributor III
Contributor III
Author

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 ?

jwjackso
Specialist III
Specialist III

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.

shmkmr90
Contributor III
Contributor III
Author

Thank you Jerry. It looks great.