0

Filter view

I have a view that is looking up data using 

let u := ULN;
select 'Indicative Earnings' where 'Unique learner number' = u

This produces:

Screen Shot 2018-08-08 at 13.57.19

What I want is for the select field ILR Year to filter records in this view.

Is this possible?

1 reply

null
    • Sakshi_Singh
    • 6 yrs ago
    • Reported - view

    Hi Andrew,

    Pls try:

    let u := ULN;
    let y:= 'ILR Year';
    select 'Indicative Earnings' where 'Unique learner number' = u and Year = y

     

    Regards,

    Sakshi- Ninox

Login to reply

Content aside

  • 6 yrs agoLast active
  • 1Replies
  • 1635Views