Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Creator III
Creator III

Max date for a location

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

Labels (3)
1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hi 

use location as the dimension

and use this expression: 

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

View solution in original post

3 Replies
lironbaram
Partner
Partner

hi 

use location as the dimension

and use this expression: 

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

View solution in original post

davyqliks
Creator III
Creator III
Author

Hi,

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

Much appreciated 

Daniel

davyqliks
Creator III
Creator III
Author

Hey there,

This worked 100% as required, thank you so  much

regards,

Daniel