topic Re: Expression Help.. in QlikView

Expression Help..

Tue, 18 Feb 2014 19:38:33 GMT

Hi All,

Please see the attached QVW.

I'm getting the result as

1/11/2014 but expecting is 1/11/2014,P1,2014

Nicole-Smith — Tue, 18 Feb 2014 19:52:40 GMT

This thread is already being replied to here: Expression Help

Tue, 18 Feb 2014 19:56:09 GMT

Hi Nicole,

I didnt get the expected result.Not sure how to post QVW for the existing thread...so created a new thread

MK_QSL — Tue, 18 Feb 2014 20:09:14 GMT

=MAX({1<[System] = {"DAPTIVE"}>}(date([Apply to Period Date ID])))

& ',' &

Only({<System = {"DAPTIVE"}, [Apply to Period Date ID] = {"$(=Max([Apply to Period Date ID]))"}>}Period)

& ',' &

Only({<System = {"DAPTIVE"}, [Apply to Period Date ID] = {"$(=Max([Apply to Period Date ID]))"}>}Year)

Same way use for LAWSON..

Hope this help.