topic Re: Expression Help in QlikView

Expression Help

Mon, 17 Feb 2014 17:02:56 GMT

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 ?

Re: Expression Help

m_woolf — Mon, 17 Feb 2014 17:38:22 GMT

What is it displaying?

Re: Expression Help

Mon, 17 Feb 2014 17:39:29 GMT

it is not displaying anything...showing empty

Re: Expression Help

m_woolf — Mon, 17 Feb 2014 17:41:40 GMT

Can you post a sample qvw?

Re: Expression Help

m_woolf — Mon, 17 Feb 2014 17:43:20 GMT

You have a right bracket ] with no matching left bracket.

Re: Expression Help

MK_QSL — Mon, 17 Feb 2014 17:50:02 GMT

MAX({<System = {'X','Y','Z'}>}[Date ID]) or

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

Re: Expression Help

Tue, 18 Feb 2014 16:45:05 GMT

Got the answer....MAX({<System = {'XYZ'}>}[Date ID]) ..also i need to asdd the period some thing like this format ..

01/01/2013,PeriodP1 ....I have the period field...

How can we assign period ?

Re: Expression Help

juleshartley — Tue, 18 Feb 2014 17:00:21 GMT

Do you mean that you want to filter the results to show where PeriodP1 = '01/01/2013'?

Re: Expression Help

juleshartley — Tue, 18 Feb 2014 17:03:31 GMT

If so, you need to use syntax similar to :

MAX(

{

<System={'XYZ'},

PeriodP1={$(vDate)}

}

[Date ID]

)

where vDate is set to the filter date. But be careful - dates are trickly to get right!

Re: Expression Help

MK_QSL — Tue, 18 Feb 2014 17:34:31 GMT

What is the comparison criteria for PeriodP1?

Re: Expression Help

Tue, 18 Feb 2014 17:40:02 GMT

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

Re: Expression Help

MK_QSL — Tue, 18 Feb 2014 17:52:20 GMT

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?

Re: Expression Help

Tue, 18 Feb 2014 18:10:49 GMT

yes..p1 is period1...

Re: Expression Help

Tue, 18 Feb 2014 18:21:07 GMT

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

Re: Expression Help

MK_QSL — Tue, 18 Feb 2014 19:26:27 GMT

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

Re: Expression Help

Tue, 18 Feb 2014 19:28:09 GMT

Thanks

Re: Expression Help

Tue, 18 Feb 2014 19:39:13 GMT

Hi Manish,

Posted QVW in the below link..

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

Re: Expression Help

MK_QSL — Tue, 18 Feb 2014 20:09:41 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.

Re: Expression Help

Tue, 18 Feb 2014 20:16:07 GMT

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)

Re: Expression Help

MK_QSL — Tue, 18 Feb 2014 20:48:41 GMT

Will check tomorrow and reply back to you.