Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
brindlogcool
Contributor 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.

Tags (2)
5 Replies
mov
Esteemed Contributor III

Re: Getpossible Values

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
Contributor III

Re: Getpossible Values

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

mov
Esteemed Contributor III

Re: Getpossible Values

A text box with concat() function

brindlogcool
Contributor III

Re: Getpossible Values

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.

mov
Esteemed Contributor III

Re: Getpossible Values

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

Regards,

Michael