data association of the fields

[sonysree88]

Hi All,

I can have 1 filed that year : 2013,2014,2015 .

One employee is working in 2013,2014,2015

If i can select 2013 from the list box 2013 data and as well as association is nothing but if we can have same employee in 2014 that should also display.

Regards,

Sonysree

[Jacek]

May I ask you to provide target table ? If you select only year 2013 but in table you have Employees list then association should be worked correctly

[sonysree88]

Below is the table:
Emp, Year , Sal
101 2013 10k
102 2013 20k
103 2013 ....
104 2013 ....
105 2013
101 2014
103 2014
105 2014
106 2014
107 2014
102 2015
103 2015
106 2015
107 2015
108 2015 ...
109 2015 and soon upto 10bil records
Here am taking the list box as Year.

If i can select the 2013 year same employee is working in 2014 and 2015 so those records needs be displayed as per year selection only.

I don't want take EMP id as list box to select.

PFA QVW:

[Jacek]

Please try:

Source:
LOAD * INLINE [
EMP, Year, SAL
101, 2013, 10k
102, 2013, 10k
103, 2013, 10k
104, 2013, 10k
105, 2013, 10k
101, 2014, 20k
103, 2014, 20k
105, 2014, 15k
106, 2014, 10k
107, 2014, 10k
102, 2015, 25k
103, 2015, 30k
106, 2015, 20k
107, 2015, 20k
108, 2015, 10k
109, 2015, 10k
];

EMP_Year:
Load distinct
  EMP,
  Year as [Base Year]
Resident Source;

In dashboard use [Base Year] for selecting.

[VishalWaghole]

Could you please explain bit more.

Where exactly you want to display those employee who worked in all years i.e. 2014, 2015, 2016...

If you want to display it in any charts, straight table or pivot table then it will automatically display as if employee is associate with year.

Regards,
Vishal Waghole