Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
brindlogcool
Creator III
Creator III

Getpossible Values

Is there any way to get only the possible values other than the Macro function Getpossiblevalues and P(). I want to display the only the possible values in the List box.

5 Replies
Anonymous
Not applicable

If you want to  displayonly possible values in a list box, check the box "Hide Excluded" in the list box properties, tab General.

Regards,

Michael

brindlogcool
Creator III
Creator III
Author

Thanks Michael to mention it. I forget to mention in the above description i tried it but it is not working for the tree view.

Any other suggestions????

Anonymous
Not applicable

A text box with concat() function

brindlogcool
Creator III
Creator III
Author

Thanks for the response and sorry for not providing the complete details. I want to display the tree  view only possible values. The expression i am using is allowing me to get the functionality but it is restricting the usablilty as it is not allowing to select the parent (Which will let all the childrens get selected)

Now i need to each individual child has to be selected.

So i am using this expression to limit the listbox for only possible values

=aggr(only({<Ty= P(Ty)>}Ty),Ty)

Is there any other way we can create an expression to limit the list box to limit the possible values.

Anonymous
Not applicable

Sorry, cannot help with this.  I would require more time than I can afford now, and no guarantee of result.

Regards,

Michael