Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HOW TO WRITE it

what is wrong with the expression(aggr is wrong):

sum({<inpdate={'<=$(=date($(saldate)))

>=aggr(min({<inpdate={'<=$(=date($(enddate)))>=$(=date($(startdate)))'}>}inpdate),SERIALNO)

'}>} SALES)

the third get the min date by serialno

29 Replies
jagannalla
Partner - Specialist III
Partner - Specialist III

Can you share your file here.

Not applicable
Author

Jagan,

sorry, but are you sure, that this part:

$(=Min({<NumINPDATE={">=$(vStart)<=$(vEnd)"}>}INPDATE))

will give result regarding dimension value?



Not applicable
Author

if I change startdate to 2013/01/18,B should be 14 not 20.

jagannalla
Partner - Specialist III
Partner - Specialist III

Dariusz Mielczarek,

Please check my attachments in above conversation, It matches the output result what Jack he is expecting. Let me know if you have any queries.

Thanks,

Jagan

Not applicable
Author

yes. this date is ok. like the date for B is 2013/01/30

Not applicable
Author

Ok, i will if i only get new license

look:

$(=Min({<NumINPDATE={">=$(vStart)<=$(vEnd)"}>}INPDATE))



$(= )

In my oppinion it will give only one date point for entire SERNO poppulation. But Jack needs here 1 date for each SERNO....

Because each of SERNO may have different min INPDATE between start and end date




Not applicable
Author

Not applicable
Author

yes ,I should get the min date for each SERNO. I hope to use aggr ,but It don't work.

Not applicable
Author

I have to go home now.

If there will be still no solution, i will try to do something more with this subject today evening (we have 17:00 now).

regards

Darek

male_carrasco
Creator
Creator

Try this

=Sum({<SALDATE={'>=$(=Min({<INPDATE={">=$(vStart)<=$(vEnd)"}>}INPDATE))<=$(vSaleDate)'}>}SALQTY)