Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Expression help

Hi

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

1 Solution

Accepted Solutions
Highlighted

Try this:

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

View solution in original post

2 Replies
Highlighted

Try this:

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

View solution in original post

Highlighted
Creator
Creator

Thanks Sunny, that works perfectly