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
Contributor III
Contributor III

Checking Date equality in expression

I am trying to get this expression right.

What I need is the value 'Close' whe the 'begindate' = Min('begindate). My expression below is in error. What is the right expression.

= Num( ( { < begindate =  { Min([begindate]) } >} Close) ,'##.#0')

Thanks

1 Solution

Accepted Solutions
Highlighted

May be this

= Num(Sum({<begindate =  {"$(=Min({<Close = {'*'}>}[begindate]))"}>} Close) ,'##.#0')

View solution in original post

3 Replies
Highlighted
Master II
Master II

maybe this:

= Num( sum( { < begindate =  { '=Min([begindate])' } >} Close) ,'##.#0')

Highlighted
Contributor III
Contributor III

But it is summing all the values.Not sure why the begindate = Min(begindate) filter is not getting applied.

Highlighted

May be this

= Num(Sum({<begindate =  {"$(=Min({<Close = {'*'}>}[begindate]))"}>} Close) ,'##.#0')

View solution in original post