topic Re: Help with an Expression in QlikView

Help with an Expression

Anonymous — Wed, 03 Jun 2015 14:50:26 GMT

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

Re: Help with an Expression

swuehl — Wed, 03 Jun 2015 14:59:44 GMT

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

Re: Help with an Expression

Anonymous — Wed, 03 Jun 2015 15:04:04 GMT

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.

Re: Help with an Expression

swuehl — Wed, 03 Jun 2015 15:11:09 GMT

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.

Re: Help with an Expression

Anonymous — Wed, 03 Jun 2015 15:26:05 GMT

This seems to work perfectly.

Thank you!