topic Re: Getpossible Values in QlikView

Getpossible Values

brindlogcool — Thu, 13 Jun 2013 16:04:04 GMT

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.

Re: Getpossible Values

Anonymous — Thu, 13 Jun 2013 16:12:05 GMT

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

Re: Getpossible Values

brindlogcool — Thu, 13 Jun 2013 16:40:52 GMT

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

Re: Getpossible Values

Anonymous — Thu, 13 Jun 2013 16:44:28 GMT

A text box with concat() function

Re: Getpossible Values

brindlogcool — Thu, 13 Jun 2013 16:54:01 GMT

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.

Re: Getpossible Values

Anonymous — Thu, 13 Jun 2013 17:12:39 GMT

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

Regards,

Michael