Min Date

[dseelam]

Hello all,

In below QVW I created a expression Min Date Where I need to show only if INVB<0 give me min date for current selection for particular item&Org

Some how my expression seems wrong Can some one help me putting these in to set analysis

attached samples

thanks,

D

[aarkay29]

try this

Min({<INVBAL= {"=$(=sum(INVBAL)<0"} >}WKDT)

[avinashelite]

Or

if(INVB<0,min(WKDT))

You cannot use the Expression Name directly in the set Analysis

[dseelam]

Hello Aar,

it gave be Blanks results

[vishsaggi]

What is your expected output?

[avinashelite]

Did you check my expression ? and don't create duplicate treads

[dseelam]

Hello Nag,

My expected out put is I need min of date when that particular item turns in to negative group by ORG

I need min date for particular item for that particular org once the INVBAL start turning negative

in below case 7/3/17 is the date

example:

[dseelam]

hey Avi,

your expression is correct if I am looking at whole dashboard but I need min(date) for every single item group by org I rephrased my question as

My expected out put is I need min of date when that particular item turns in to negative group by ORG

I need min date for particular item for that particular org once the INVBAL start turning negative

in below case 7/3/17 is the date

[vishsaggi]

Check this attached?

[aarkay29 · Accepted solution]

Do you mind if its in the script:

Table:

LOAD

     ITEM,

     ORG,

     Date( WKDT) as WKDT,

     SPLY,

     DMND,

      INVBAL,

     If(INVBAL<0,WKDT) as TempDate

FROM

     (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Left Join (Table):

LOAD 

     ORG,

     ITEM,

     Min(TempDate) as MinDate 

Resident

     Table;

Group By

     ITEM,ORG;

Drop Field TempDate;