Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

FORMULA

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

1 Solution

Accepted Solutions
kaushiknsolanki

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

14 Replies
kaushiknsolanki

Hi,

     Try this.

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
its_anandrjs

Try to remove equal sign

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

Not applicable
Author

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

Not applicable
Author

I cann't work

kaushiknsolanki

Dear Jack,

     Kindly explain in Detail, if possible with exmaple

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

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

kaushiknsolanki

Dear Jack,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable
Author

COMPANYITEMINDATEsum({<dealdate={">=-<=2014/3/13"}>} qty)
A112014/1/130
A122014/1/210
A132014/1/320
B122014/1/220
B152014/1/50
B172014/1/70
B212014/1/10
C142014/1/420
C162014/1/630
C182014/1/80
C192014/1/90

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

kaushiknsolanki

Hi,

     So in short you need cumulative values?

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".