Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sivaboggarapu20
New Contributor III

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
MVP
MVP

Re: QuarterStart date is showing 10/1/2018?

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)

4 Replies
MVP
MVP

Re: QuarterStart date is showing 10/1/2018?

What is the Max(Date) showing?

sivaboggarapu20
New Contributor III

Re: QuarterStart date is showing 10/1/2018?

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

MVP
MVP

Re: QuarterStart date is showing 10/1/2018?

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
New Contributor III

Re: QuarterStart date is showing 10/1/2018?

Hi Sunny,

Excellent its working fine

Thank you so much for quick response

Thanks,

Siva