Current Quarter Data

[#1]

How can we calculate current quarter sales in qlikview?

[Kushal_Chawda]

try this

=Sum({<MonthYear= {">=$(=Date(Quarterstart(max(MonthYear)),'MMM-YY'))<=$(=date(max(MonthYear),'MMM-YY'))"}>}Sales)

[#3]

Thanks Kushal, it worked.

But when I applied filter it showed me 0 for all the rows.

As per the below data, when I applied filter of Actaul_Goal then it returned me null value.

Date     Actual_Goal     Value

Jan-16     Actual     50

Feb-16     Actual     60

Mar-16     Actual     70

Apr-16     Actual     80

May-16     Goal     90

Jun-16     Goal     100