topic Re: Min Date in QlikView

Min Date

dseelam — Thu, 23 Feb 2017 14:12:41 GMT

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,

Re: Min Date

aarkay29 — Thu, 23 Feb 2017 14:20:22 GMT

try this

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

Re: Min Date

avinashelite — Thu, 23 Feb 2017 14:25:31 GMT

if(INVB<0,min(WKDT))

You cannot use the Expression Name directly in the set Analysis

Re: Min Date

dseelam — Thu, 23 Feb 2017 14:28:14 GMT

Hello Aar,

it gave be Blanks results

Re: Min Date

vishsaggi — Thu, 23 Feb 2017 14:37:52 GMT

What is your expected output?

Re: Min Date

avinashelite — Thu, 23 Feb 2017 14:41:24 GMT

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

Re: Min Date

dseelam — Thu, 23 Feb 2017 16:21:13 GMT

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:

Re: Min Date

dseelam — Thu, 23 Feb 2017 16:23:35 GMT

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

Re: Min Date

vishsaggi — Thu, 23 Feb 2017 16:47:32 GMT

Check this attached?

Re: Min Date

aarkay29 — Thu, 23 Feb 2017 17:10:44 GMT

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;

Re: Min Date

dseelam — Thu, 23 Feb 2017 20:00:15 GMT

Great It worked thank you Aar