Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
diwakarnahata
Creator
Creator

GetPossibleValues equivalent

Hi,

I want to select one field based on Possible values in Second field, without using macros.

I tried using field event triggers, but how can i get the Possible values for field1 to trigger field2?

Not sure if there is a way using indirect set analysis to get the possible values.

Please suggest.

Regards,

Diwakar

3 Replies
MK_QSL
MVP
MVP

You can use P() and E() of set Analysis. If you would be more specific on your requirements with possibly some sample data, would like to work on this..

diwakarnahata
Creator
Creator
Author

Hi Manish,

Thank you for the response. Attached is a dummy qvw with the use case.

I have created two copies of the Product hierarchy - Pr_Dim and Pr2_Dim. When i select any element from Pr2_dim (for e.g. PSubC2) i need to trigger the association of Pr2_id into Pr_id. For that i need to get the possible values of Pr2_id which i can use to trigger Pr_id.

Let me know if there are any better approaches.

Regards,

Diwakar

diwakarnahata
Creator
Creator
Author

Adding Attachment