topic Re: Checking Date equality in expression in QlikView

Checking Date equality in expression

sqlpuzzle — Wed, 25 Nov 2020 16:16:04 GMT

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

Frank_Hartmann — Mon, 16 Oct 2017 13:20:54 GMT

maybe this:

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

sqlpuzzle — Mon, 16 Oct 2017 13:30:16 GMT

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

sunny_talwar — Mon, 16 Oct 2017 13:33:44 GMT

May be this

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