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: 
ashokraju
Contributor II
Contributor II

Qlikview

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.

6 Replies
adamdavi3s
Master
Master

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

Not applicable

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 .

ashokraju
Contributor II
Contributor II
Author

Hi Ramu..both are from different tables.

ashokraju
Contributor II
Contributor II
Author

could you please explain more

adamdavi3s
Master
Master

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

ramasaisaksoft

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.