topic Re: Expression not working in QlikView

Expression not working

QFanatic — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Please find below my problem. My Table only contains these 4 fields and a variable called vPreviousPeriod that is equal to 201910 at the moment.

I've created 2 textboxes so you can see what I am trying to do. The top one, shows the expression I'm using. The bottom one, the result.

I want to get the FINYR_CALL for the max(CALLMONTH) but its not working.

Please may you assist with my expression?

Thanks

Re: Expression not working

rwunderlich — Thu, 23 Jan 2020 14:24:56 GMT

Because FINYR_CALL is a string, the Max() function will not work. Max() only works with numeric values.

Use MaxString() instead. Since there only seems to be a one-to-one between CALLMONTH and FINYR_CALL, you could use Only() as well, which I think would be preferable.

=only({<CALLMONTH = {"$(='$(vPreviousPeriod)')"}>}FINYR_CALL)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Expression not working

QFanatic — Thu, 23 Jan 2020 14:46:54 GMT

Thank you Rob, much appreciated.