Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..I have two years Lost year and Booked year. In the 'Bookings' tab iam using booked year and the 'Lost' tab iam using lost year.
I have multiple years like 2011 to 2016 in both booked year and lost year.
My scenario is if I select 2015 in booked year in 'Bookings' tab automatically 2015 is selected in lost year in 'Lost' tab. How it is possible. Please suggest on this.
You can do this with:
1- A linked calendar
2- by using a field trigger
- add an on select trigger and an on change trigger to both fields to they mimic each other
3- use set analysis
Hi Raju,
the both fields Lost year and Booked year are in same table?
In qlikview, if you select any value in on tab that value related tabs also highlighted .
Hi Ramu..both are from different tables.
could you please explain more
If I were doing it then I would use field triggers, please see the attached which is a simple explanation (make a selection in s_code and watch e_code
See settings > document properties > triggers
Then look at the field event triggers for S_CODE
Hi Ashok,
your doubt will clear in your data model
Case 1:-I hope they created Master calendar and they rename/Alias same field twice as Lost year,Booked year
Case 2:-may be these 2 calender's are controlled in Variables
List box properties->Min value & Max value they controlled with same field.
and these 2 tables are joined with Year Field so better to post your script or your data model,so that our folks will do more help for the same.