Compare the two Years in the table and display the records not in 2014

[#1]

I have to compare the values of 2013 and 2014 in (STD_DT )and the resulting table
should display the find the missing NCKID in 2014 .

Please find the attached qvw

[sasikanth]

HI senthil

try some thing like this

if( if(Right(STD_DT,4)<2014,NCKID)= if(Right(STD_DT,4)<2015,NCKID),NCKID,null())

Hope this will help u

[sujeetsingh]

Kumar,

I will suggest you to do the handling in script rather then going to UI

[tresesco]

Better to do it in the script. Otherwise for front end:

=Concat( distinct {<NCKID=P({< STD_DT={"=year(Date#(STD_DT,'DD-MM-YYYY'))=2013"}>})> - <NCKID=P({<STD_DT={ "=year(Date#(STD_DT,'DD-MM-YYYY'))=2014"}>})>} NCKID,',')           

PFA