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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Current Quarter Data

How can we calculate current quarter sales in qlikview?

11 Replies
Kushal_Chawda

try this

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

Not applicable
Author

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