Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Kumar,
I will suggest you to do the handling in script rather then going to UI
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