Skip to Content
0
Jun 05, 2018 at 12:51 PM

FILTER DATA BASED ON RANGE VALUES IN HANA

1502 Views

Hi Experts,

I'm trying to get active employess from the table. it looks like as shown as below:

I created a simple calculation view and create two input parameters which is used in the projection node to filter the data and as shown as below:

Filter Expression:

"START_DATE" <= $$IP_EDATE$$ AND  "END_DATE" >= $$IP_SDATE$$

My need is can i use single input parameter to filter the data....???

Thanks in advance

Attachments

sp.png (7.2 kB)