topic Expression help in QlikView

Expression help

yvonne-c — Wed, 25 Nov 2020 16:16:04 GMT

I have the following expression in a chart, which works fine

=round([Last calving]-[Date of birth])/30.4

I want to add the following selection to the expression but cant get it right

{<[Lact. no.]={1}>}

I have tried this:

=round({<[Lact. no.]={1}>}[Last calving]-[Date of birth])/30.4

Can anyone advise what I'm doing wrong?

Thanks

sunny_talwar — Thu, 28 Apr 2016 15:21:35 GMT

Try this:

=Round(Only({<[Lact. no.]={1}>} [Last calving]-[Date of birth]))/30.4

yvonne-c — Thu, 28 Apr 2016 15:52:28 GMT

Thanks Sunny, that works perfectly