topic Re: GetPossibleValues equivalent in QlikView

GetPossibleValues equivalent

diwakarnahata — Thu, 02 Apr 2015 10:59:06 GMT

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

Re: GetPossibleValues equivalent

MK_QSL — Thu, 02 Apr 2015 11:10:30 GMT

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

Re: GetPossibleValues equivalent

diwakarnahata — Fri, 03 Apr 2015 10:18:27 GMT

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

Re: GetPossibleValues equivalent

diwakarnahata — Fri, 03 Apr 2015 10:20:06 GMT

Adding Attachment