Data for May showing as Q1

[Kaushik2020]

i have selected below options as part of Filters. 

I am using below in load editor to calculate Quarter.

'Q' & ceil(month(act_date)/3) as "Quarter"

Please see below line chart, it shows the point as Q1 which is misleading.

my expression to calculate the count.

if(count(distinct{<[Activation Year]=, [Activation Month]=, [Activation Quarter]=, current_fraud_bad_debt_category={'Fraud'},
act_date={">=$(=date(yearstart(max(act_date))))<=$(=date(monthstart(addmonths(max(act_date),-3))))"}>} contract_id)
+
Sum({<act_date={">=$(=date(monthstart(addmonths(max(act_date),-3))))<=$(=date(max(act_date)))"}>}projected_fraud_cnt)=0, null(),
count(distinct{<[Activation Year]=, [Activation Month]=, [Activation Quarter]=, current_fraud_bad_debt_category={'Fraud'},rp_type={'POSTPAID VOICE'},
act_date={">=$(=date(yearstart(max(act_date))))<=$(=date(monthstart(addmonths(max(act_date),-3))))"}>} contract_id)
+
Sum({<rp_type={'POSTPAID VOICE'},act_date={">=$(=date(monthstart(addmonths(max(act_date),-3))))<=$(=date(max(act_date)))"}>}projected_fraud_cnt))

[rwunderlich]

Your expression to calculate Quarter looks to correct. To debug, make yourself a table chart of act_date, Month(act_date) and Quarter to see if you can determine what's happening. 

-Rob

[Kaushik2020]

Thanks for your reply. Seems we are showing data for Selected month -3. My bad that forgot to check. 

So here in this case when selected month is May-which is Q2. we are showing data for Jan which is Q1. 

I think that's the reason QlikSense is showing the Count under Q1.