Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mcaahmad93
Contributor
Contributor

Merge the two table date selection without any link of data model.

Hi Team,

I have two from date and  to date.Provided the below screenshot for reference.

clipboard_image_3.png

Scenario

  1. if i select the "line of trend" from and to date then same from and to date should select on "Repair" from date and to date.
  2. User can also select the "Repair" from and to  date but it should between date of "Line of Trend" date.

I am using below expression to achieve this, it  is working but between date logic i don't have idea how get in "Repair "from and to date.

=RPFromDate&' - '& LOFromDate

Note:There is no link between "Line of trend "and "Repair" date.

Please help me to complete this.

Regards,

Irsahd Ansari

Labels (2)
3 Replies
dplr-rn
Partner - Master III
Partner - Master III

If theres not link between the 2 data sets

few options

1- did you try triggers? selection of line of trend triggers selection of the repair

2- canonical date  and use a single calendar selection

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

3-  or an island master calendar and use single calendar selection and set analysis

mcaahmad93
Contributor
Contributor
Author

Thank you Dilip for your valuable time.

- did you try triggers? selection of line of trend triggers selection of the repair-->No, Please share the logic.

I need to achieve this in presentation layer.

Regards,

Irshad Ansari

 

dplr-rn
Partner - Master III
Partner - Master III

Basically use field event triggers to set fields on selection of another.

check solution in below communuity link for a starting point.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Use-trigger-to-select-values-in-one-fie...