Min date for current selection

[dseelam]

Hello all,

I have 3 columns Item, INVB AND Date, I need to create a expression saying that if INVB<0 give me min date for current selection for particular item 

Can some one help me putting these in to set analysis

thanks,

D

[vishsaggi]

May be this?

= Min({< INVB = {'<0'} >} Date)

[shraddha_g]

Min({$<INVB={"<0"}>}Date)

[Anonymous]

Understanding the query, we need Min(Date) where INVB<0. So using the set Analysis, INVB is equal to(=) the set of values which satisfy condition (<0 ).  put Where clause in the braces.like {<INVB={" < 0"} >}. Makes it

Min({<INVB= {"< 0"} >}Date).

The expression within the " " is evaluated and will get the required result.

You can use this expression against the item as the dimension in a table and can get the value of each item against it.

Hope it helps.

[dseelam]

below error has been occurred when trying to implement above solution mentiones

[vishsaggi]

What is the error you are getting? Even though you are getting those squiggly line did you press ok and checked? Is your INVB a calculated expression?

[vishsaggi]

Seems you have duplicate thread here?

Min Date

[avinashelite]

Try like this

if(INVB<0,min(WKDT))

You cannot direct use the expression name in the set analysis

[dseelam]

Yes Nag, I did attached a working test file attached in this thread can you check it, I don't know hoe to attach same files in this reply

[vishsaggi]

Ok, did you try what avinash suggested? And also can you tell us what is your expected output should be for MinDate?