topic Re: Get associated value from a Field in QlikView

Get associated value from a Field

microwin88x — Thu, 06 Mar 2014 13:25:32 GMT

Hello!

I have two fields, Zone and Office.

1 Zone -> N Offices

And every Office is associated to one Zone

If I select a particular Office, I want to know if there's any function to get the associated Zone to that selected Office.

Is there any way to do that?

Thank you!!!

MK_QSL — Thu, 06 Mar 2014 13:31:05 GMT

Create a text box and type below...

=CONCAT(DISTINCT ZONE,', ')

Thu, 06 Mar 2014 13:35:06 GMT

Only(ZONE)

will only work when you select an office

there is a few ways to get that value, I believe the above is best

else Maxstring(ZONE)

or FieldValue('ZONE',1)

or CONCAT(DISTINCT ZONE,', ') as per Manish