Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Assigning variable based on selection and lookup/linked table

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

1 Reply
jwjackso
Specialist III
Specialist III

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

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