Expression Help

[#1]

Hi All,

I need an expression for  Max of dateid for system = 'XYZ'...

MAX({<System = {"XYZ"}>}(date( Date ID])))..it is not displaying the date .Can anyone help ?

[#2]

I need the result something like this

01/01/2013,P1 (I'm getting just 01/01/2013)..I have a field for Period but not sure how to assign

[MK_QSL]

You mean to say using

MAX({<System = {'XYZ'}>}[Date ID])

You got result as 01/01/2013 but you want 01/01/2013, P1 ?

Am i correct?

If yes, let us know what is P1?

[#4]

yes..p1 is period1...

[#5]

I have a field called period to display p1,p2 ...

[MK_QSL]

Ok.. next question is how Peroid is Connected with DATE?

[#7]

Thanks

[#8]

Hi Manish,

Posted QVW in the below link..

http://community.qlik.com/message/471254#471254

[MK_QSL]

=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.

[#10]

HI Manish,

I'm not getting for the Lawson....It is getting only for Daptive....2/1/2014.P2,2014

Getting the result fot Daptiv as expected ..But not for Lawson...11/2/2013,, (Period is missing)

[MK_QSL]

Will check tomorrow and reply back to you.