topic Re: Max date for a location in QlikView

Max date for a location

davyqliks — Sat, 16 Nov 2024 01:47:07 GMT

Hi,

In a table with Location as a dimension and

Date(Max([%VoucherDate]))

as the expression i am getting a correct return for each of the locations showing the latest date imported.

I am trying to display this in separate charts so i use the following:

enable conditional Dimension of Location as

sum({<Location={LTR}>}Location)

with the expression

Date(Max([%VoucherDate]))

But this is not pulling the correct date

How can i show the max [%VoucherDate] for a fixed [Location] of LTR

Am i using the enable conditional Dimension correctly here?

Thank you in advance, any help/suggestions would be very appreciated

lironbaram — Wed, 04 Dec 2019 12:36:41 GMT

use location as the dimension

and use this expression:

Date(Max({<Location={LTR}>}[%VoucherDate]))

davyqliks — Wed, 04 Dec 2019 13:41:02 GMT

Hi,

Thank you so much....Giving this a try now and will report back shortly.

Much appreciated

Daniel

davyqliks — Wed, 04 Dec 2019 13:41:45 GMT

Hey there,

This worked 100% as required, thank you so much

regards,

Daniel