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: 
sivaboggarapu20
Partner - Creator
Partner - Creator

QuarterStart date is showing 10/1/2018?

Hi Team,

I Wrote below expression. QuarterStart date should show 4/1/2018. But below expression is showing Quarterstart date is 10/1/2018?


Can any one help me?

sum({<Date=, Year=, Month=, Quarter=, Date={">=$(=QuarterStart(Max(Date)))<=$(=Max(Date))"}>}BlendedCost)

Thanks,

Siva

1 Solution

Accepted Solutions
sunny_talwar

So, you want it based on today() not Max(Date) it seems... how about this?

sum({<Date=, Year=, Month=, Quarter=, Date={">=$(=QuarterStart(Today()))<=$(=Today())"}>}BlendedCost)

View solution in original post

4 Replies
sunny_talwar

What is the Max(Date) showing?

sivaboggarapu20
Partner - Creator
Partner - Creator
Author

Hi Sunny,

Max(Date) is showing 12/1/2018.

Using above expression I need to find Quarter sales from 4/1/2018 to 6/30/2018

Thanks,

Siva

sunny_talwar

So, you want it based on today() not Max(Date) it seems... how about this?

sum({<Date=, Year=, Month=, Quarter=, Date={">=$(=QuarterStart(Today()))<=$(=Today())"}>}BlendedCost)

sivaboggarapu20
Partner - Creator
Partner - Creator
Author

Hi Sunny,

Excellent its working fine

Thank you so much for quick response

Thanks,

Siva