Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis for Date between Date1 and Date2

Hi Guys,

I need to calculate the sum, when Recog_Date is >Today AND <= QuarterEnd.

The line below is working

Sum( {<Recog_Date= { ">$(=Date(Today(),'DD/MM/YYYY')) <=30/06/2011"}>} RevenueProductYTD)

but when changing as follows I get a wrong result:

Sum( {<Recog_Date= {">$(=Date(Today(),'DD/MM/YYYY')) <= $(=Date(QuarterEnd(Today()),'DD/MM/YYYY'))"}>} RevenueProductYTD)

What's missing?

Thanks in advance,

Aldo.

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

I solved it as below:

{<

Recog_Date={">$(=Date(Today(),'DD/MM/YYYY')) <=$(=Date(QuarterEnd(Today())+1,'DD/MM/YYYY'))"}>} RevenueProductYTD

)

Thanks,

Aldo.





View solution in original post

2 Replies
Not applicable
Author

Normal 0 21 false false false DE X-NONE X-NONE MicrosoftInternetExplorer4

Hi,

in your example with the coded date you are 3 months ahead:

30/06/2011.

If you try your set-expression and you tried it on the posting date,

it won't get a result:

quarterEnd of 31/03/2011 is 31/03/2011. So you try:

>31/03/2011 and <= 31/03/2011..

HTH

Not applicable
Author

Hi,

I solved it as below:

{<

Recog_Date={">$(=Date(Today(),'DD/MM/YYYY')) <=$(=Date(QuarterEnd(Today())+1,'DD/MM/YYYY'))"}>} RevenueProductYTD

)

Thanks,

Aldo.