Discussion board where members can get started with QlikView.
Dear QlikView Team,I want ur helpi want those emp are 'ac' active for year 2012. and also have promotion 'f' for the following yrs 2010,2011,2012 Re: Logic Problem
can you be more specific please? Do you need a script?
Is the table your source data? What is your goal?
The above table is my data.
I want that employee who has promotion ='f ' for year(2010,2011,2012) and that employee should also be active 'ac' in 2012 year
=if(Active='ac' and FinFlag=2012
use this expression in ur calculated dimension