# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for
Search instead for
Did you mean:
Partner

## Calculate quarters depending selected month

Hello all, I want to calculate  my quarters into my table measures depending on the selected month into my app, I'm using the next function in for the first Quarter. if(Month > '3',Sum({\$< Year={\$(=Max(Year))} ,Month = {\$(=Month(Date#(Max(Month)-2, 'M'))),\$(=Month(Date#(Max(Month)-1, 'M'))),\$(=Month(Date#(Max(Month), 'M')))}>} [CantidadVen]), if(Month <='3', Sum({\$< Year={\$(=Max(Year)-1)} ,Month = {\$(=Month(Date#(Max(Month)+10, 'M'))),\$(=Month(Date#(Max(Month)+11, 'M')))},Year={\$(=Max(Year))},Month = {\$(=Month(Date#(Min(Month), 'M')))}>} [CantidadVen]),0 ) ) But this not getting to me the result what im looking for. Someone did calculate Quarters depneding on the selected month  before? I will apprecciate alot your help. Regards.
0 Replies
Tags