Assigning variable based on selection and lookup/linked table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a multibox with listing of quarters from Table A that are in format "<YYYY>Q1", which represents the initial quarter. I have a Table B that includes a listing of quarters in this format (first column) and corresponding quarter end date in date format (i.e., MM/DD/YYYY) (third column) (I have another column in-between). The QlikView data model has Table A and B linked. Based on user selection, how do I assign the actual date in Table B to a variable? I may be able to change the format of the field in Table A to an actual date but I have other reasons I want to keep as is for now so want to see if this approach works.

Not the subject of this post but just to give a little more information where I'm heading in case it matters...I'll be using this date to determine starting point for a line graph with 2 years of quarter dates on the x-axis. I'll probably have additional posts for this project but want to keep posts to a particular task.

Thanks in Advance,

Barry

Re: Assigning variable based on selection and lookup/linked table

jwjackso — Mon, 11 Jun 2018 21:50:48 GMT

Check out triggers: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Document_Properties_Triggers.htm

You can use a 'onselect' field trigger to set a variable.

topic Assigning variable based on selection and lookup/linked table in QlikView

Assigning variable based on selection and lookup/linked table

Re: Assigning variable based on selection and lookup/linked table