Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
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.

Labels (1)
4 Replies
Specialist II
Specialist II

why dont you extract the quarters in the load script itself.

it can be done like :

'Q' & CEIL(NUM(MONTH(CALENDAR_DATE))/3) AS CALENDAR_QUARTER,

Partner
Partner

Hello i already tried this,

But load this into the script only will give me static Quarters(Jan-Marc,Apr-Jun,Jul-Sep,Oct-Dec) i want dynamic quarters like, if i select january into the months the first quarter should be (Jan2020-Nov2019) and before.

 

Rergards

Specialist II
Specialist II

hows your Financial year defined?

Does nov 2019 - jan2020 mean Quarter 1 for you?

Partner
Partner

Not really

Let me me give you an example, the final user select april 2019, so my frist quarter should be (Apr2019-Feb2019) the next quarter(Jan2019-Nov2018) next one (Oct2018-Aug2018) and the last one (Jul2018-May2018) but the final user want to change the selected month to January 2020, so the period should change, the first quarter should be (Jan2020-Nov2019) and etc.

Regards