topic Re: latest date in QlikView

latest date

Anonymous — Wed, 23 Jul 2014 11:36:47 GMT

Good day!

How i can get latest date with added condition?

For this table i must get latest date, where the quantity > 2 (09.11.2013)

date	Quantity
12.11.2013	2
09.11.2013	3
08.11.2013	4
07.10.2013	6
06.10.2013	8

Thank you!

Re: latest date

vardhancse — Wed, 23 Jul 2014 11:37:46 GMT

use max(date) it will give u the latest date

Re: latest date

Anonymous — Wed, 23 Jul 2014 11:42:46 GMT

Use this

=Max(Date)

Re: latest date

vardhancse — Wed, 23 Jul 2014 11:44:00 GMT

create one variable:

let vDate = vMax(date)

Expression for Eg:

count({$<Date=vMax(date)>}Account)

Re: latest date

Anonymous — Wed, 23 Jul 2014 11:45:21 GMT

if i will use only =Max(Date), i'll get 12.11.2013, but it's wrong for my task.

i want to get max date, where quantity > 2

correct date must be 09.11.2013

Re: latest date

Anonymous — Wed, 23 Jul 2014 11:49:38 GMT

ok, for your expression,

what it will give me with my data ?

date	Quantity
12.11.2013	2
09.11.2013	3
08.11.2013	4
07.10.2013	6
06.10.2013	8

Re: latest date

vardhancse — Wed, 23 Jul 2014 11:49:47 GMT

so you are trying to get the count where account>2 or

account>2 only for the latest date

Re: latest date

lironbaram — Wed, 23 Jul 2014 11:49:53 GMT

so you can use max({<quantity={">2"}>}Date)

and if you need to aggregate the quantity than use

max(aggr(if(sum(quantity)>2,Date),Date))

Re: latest date

vardhancse — Wed, 23 Jul 2014 11:51:05 GMT

here max(date)=12.11.2013 so the count will be 2

Re: latest date

mahesh_agrawal — Wed, 23 Jul 2014 11:52:43 GMT

Hi,

PFA

Re: latest date

Anonymous — Wed, 23 Jul 2014 11:56:10 GMT

but my task is to get max date, where quantity > 2 !!!!!!!!!!!!!!!!

(09.11.2013)

Re: latest date

lironbaram — Wed, 23 Jul 2014 11:59:29 GMT

so you can use max({<quantity={">2"}>}Date)

max(aggr(if(sum(quantity)>2,Date),Date))

Re: latest date

vardhancse — Wed, 23 Jul 2014 12:00:59 GMT

({$<Account>'2'>}'vMaxDate')

it will display max date for account>2

Re: latest date

Anonymous — Wed, 23 Jul 2014 12:04:47 GMT

try this

Date(Max({<Quantity = {">2"}>} date),'DD/MM/YYYY')

you will get the O/P as 09/11/2013