Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with an Expression

Hi Guys,

I am currently working on a Chart,

I have ACCT_ID & Customer_Name as my dimensions.

At the minute I have one express Max(END_DT_YEARMONTH)

But basically what I am trying to find out is an expression that will only give me the ACCT_ID & Customer_Name and END_DT_YEARMONTH of customers where their Max END_DT_YEARMONTH is lower than the Highest Max END_DT_YEARMONTH available.

Hope that makes sense,

Cheers

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Ah, I see, lower not lower equal 😉

Every customer only has a single record for END_DT_YEARMONTH, right?

Maybe like this:

Reuse your straight table chart, but for the expression use:

=only({<END_DATE_YEARMONTH = {"<$(=max(END_DATE_YEARMONTH))"}>} END_DT_YEARMONTH)

Your END_DATE_YEARMONTH needs to have a numeric representation, not only being a pure text field.

View solution in original post

4 Replies
swuehl
MVP
MVP

Wouldn't that include all customers? Or can END_DT_YEARMONTH be NULL?

Anonymous
Not applicable
Author

Hi Swuehl,

Every customer has an END_DT_YEARMONTH,

For instance most will be 2015Feb, but some could be 2015Jan – These are the ones I want to be able to see.

swuehl
MVP
MVP

Ah, I see, lower not lower equal 😉

Every customer only has a single record for END_DT_YEARMONTH, right?

Maybe like this:

Reuse your straight table chart, but for the expression use:

=only({<END_DATE_YEARMONTH = {"<$(=max(END_DATE_YEARMONTH))"}>} END_DT_YEARMONTH)

Your END_DATE_YEARMONTH needs to have a numeric representation, not only being a pure text field.

Anonymous
Not applicable
Author

This seems to work perfectly.

Thank you!