topic Re: the date is wrong in QlikView

the date is wrong

Mon, 05 May 2014 08:02:18 GMT

I have get the table as the following . I get E from C & D , but the $(E) is the same value . It should DEALDATE>='20140101' for A &B company and '20140401' for company C . It get the same '20140401' value. How to do it ?

A	B	C	D	E	F
COMPANY	ITEM	INDATE	min({<DEALDATE={'<=ENDDATE>=STARTDATE'}>}DEALDATE)	if(IsNull(D),INDATE,D)	sum({<DEALDATE={">=$(E)"}>} QTY)
A	2PU82561204	20140101		20140101	5
B	2PU82561204	20140101		20140101	6
C	2PU82561204	20140101	20140401	20140401	7

Re: the date is wrong

MK_QSL — Mon, 05 May 2014 08:34:55 GMT

Didn't understand your question.

Can you please elaborate little more?

Re: the date is wrong

Mon, 05 May 2014 08:49:12 GMT

Hi,

I think your set definition for D should have double quotes instead of simple ones: {"<=ENDDATE>=STARTDATE"}

Otherwise, some sample data would help for the answer.

Re: the date is wrong

preminqlik — Mon, 05 May 2014 09:02:18 GMT

can you please elaborate more ?.....because where is deal date ?....

Re: the date is wrong

Mon, 05 May 2014 09:10:57 GMT

A,B,C column is raw data . D column is the formula value . I get E column from D column(for test ) . The F column is what I want to get . But the F column is wrong because it get the same date for company A,B,C . It should are different value for different company.

Re: the date is wrong

Mon, 05 May 2014 09:16:49 GMT

for example , company A have many dealdate for one item . the indate is only value for company&item. The startdate and enddate is input date scope. I want to sum the QTY starting from E COLUMN DATE . I set D &E COLUMN as variables.

Re: the date is wrong

anbu1984 — Mon, 05 May 2014 09:23:02 GMT

Can you provide sample data?

Re: the date is wrong

Mon, 05 May 2014 10:06:22 GMT

Dear Jack he,

You can use the below script in scripting.@@@@

Date(right(INDATE,2)&'/'&mid(INDATE,5,2)&'/'&left(INDATE,4),'DD/MM/YYYY')

Please find the attachment.

Regards,

Shrikanth H Koppad

Re: Re: the date is wrong

Mon, 05 May 2014 10:09:54 GMT

the sample is as attached.

Re: Re: the date is wrong

Mon, 05 May 2014 13:09:38 GMT

sample file