Grabbing a value without a unique flag?!

[Anonymous]

Hello all

How can I right an expression that will identify the first appearance of '1' and the last appearance of '1' and grab the value in the previous column??

I have attached a QVW to hopefully make it a little easier to understand.

I would like to be able to identify the '1103' and the '1202' so I can write 'Period between 1103-1202'.

Cheers guys

Robbie

[derekjones · Accepted solution]

Hi Robbie

Use:

='Period between ' & Min({<RollingPeriodFlag={'1'}>} Period) & ' and ' & Max({<RollingPeriodFlag={'1'}>} Period) 

All the best

Derek

[Anonymous]

Cheers Derek

I need to get my head around Set Analysis!!!!

Thanks

Robbie