topic Re: FORMULA in QlikView

FORMULA

Wed, 07 May 2014 07:58:59 GMT

as sample , I write sum({<dealdate={">=$(=date(INDATE))<=$(=date($(E)+40))"}>} qty), the indate is a fields . I can't get right answer for different indate

Re: FORMULA

kaushiknsolanki — Wed, 07 May 2014 08:04:46 GMT

Hi,

Try this.

sum({<dealdate={">=$(=date(min(INDATE)))<=$(=date($(E)+40))"}>} qty)

Regards,

Kaushik Solanki

Re: FORMULA

its_anandrjs — Wed, 07 May 2014 08:06:06 GMT

Try to remove equal sign

Sum({<dealdate={">=$(date(INDATE)) <=$(date($(E)+40))"}>} qty)

Re: FORMULA

Wed, 07 May 2014 08:12:11 GMT

the problem is that the three row is the same value 2014/01/01, It is three value

Re: FORMULA

Wed, 07 May 2014 08:12:41 GMT

I cann't work

Re: FORMULA

kaushiknsolanki — Wed, 07 May 2014 08:14:04 GMT

Dear Jack,

Kindly explain in Detail, if possible with exmaple

Regards,

Kaushik Solanki

Re: FORMULA

Wed, 07 May 2014 08:26:13 GMT

I have attached a sample.qvw . I want to get sum for different indate

Re: FORMULA

kaushiknsolanki — Wed, 07 May 2014 08:32:51 GMT

Dear Jack,

Apologies, but i am still not getting what you are looking for.

Regards,

Kaushik Solanki

Re: FORMULA

Wed, 07 May 2014 08:42:44 GMT

COMPANY	ITEM	INDATE	sum({<dealdate={">=-<=2014/3/13"}>} qty)
A	11	2014/1/1	30
A	12	2014/1/2	10
A	13	2014/1/3	20
B	12	2014/1/2	20
B	15	2014/1/5	0
B	17	2014/1/7	0
B	21	2014/1/1	0
C	14	2014/1/4	20
C	16	2014/1/6	30
C	18	2014/1/8	0
C	19	2014/1/9	0

this is a sample results . for COMANY A & ITEM 11 --- I should sum qty from 2014/1/1--- 2014/03/13 , for A&12 I sum from 2014/1/2--- 2014/03/13,

etc . If use min as you suggest , all company &item sum qty from 2014/1/1--2014/03/13

Re: FORMULA

kaushiknsolanki — Wed, 07 May 2014 08:48:01 GMT

Hi,

So in short you need cumulative values?

Regards,

Kaushik Solanki

Re: FORMULA

Wed, 07 May 2014 08:55:38 GMT

Finaly, I want to get the sum from company &item 's beginning date.

Re: Re: FORMULA

kaushiknsolanki — Wed, 07 May 2014 09:10:51 GMT

Hi,

Check the attachment, i hope this is what you want.

Regards,

Kaushik Solanki

Re: FORMULA

Wed, 07 May 2014 09:33:51 GMT

I don't need cumulative.

COMPANY	ITEM	INDATE
A	11	2014/1/1
B	12	2014/1/2

there are many deal data for company &item in different date .

finaly:

first row : I want to sum qty from 2014/01/01--- defined date.

second rom: I want to sum qty from 2014/01/02--- defined date.----- pay attention: is 01/02 not 01/01

Re: FORMULA

Wed, 07 May 2014 12:24:04 GMT

it means sum({<dealdate={">=$(=$(INDATE))<='2014/5/1'"}>} qty) don't work---- I can't get the INDATE for each item..

Re: FORMULA

kaushiknsolanki — Wed, 07 May 2014 12:26:47 GMT

Hi,

Its not possible to get the different date for each record in set analysis.

You will have to think about some other logic to achieve this.

Regards,

Kaushik Solanki