Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can we calculate current quarter sales in qlikview?
try this
=Sum({<MonthYear= {">=$(=Date(Quarterstart(max(MonthYear)),'MMM-YY'))<=$(=date(max(MonthYear),'MMM-YY'))"}>}Sales)
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