topic Re: Qlikview in QlikView

Qlikview

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

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.

Re: Qlikview

adamdavi3s — Mon, 09 Jan 2017 13:13:57 GMT

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

Re: Qlikview

Mon, 09 Jan 2017 13:19:21 GMT

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 .

Re: Qlikview

ashokraju — Mon, 09 Jan 2017 13:30:01 GMT

Hi Ramu..both are from different tables.

Re: Qlikview

ashokraju — Mon, 09 Jan 2017 13:30:37 GMT

could you please explain more

Re: Qlikview

adamdavi3s — Mon, 09 Jan 2017 13:35:06 GMT

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

Re: Qlikview

ramasaisaksoft — Mon, 09 Jan 2017 13:40:04 GMT

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.