current quarter month counts

MK9885 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I've a set expression which I need to add current quarter function.

If (GetSelectedCount ([Year List]) = 0 ,



       count ({<[P Flag] ={1}, LastMnthPerQtr={1},Num_Month = {$(=Max(Num_Month))}, [S Flag] = {1}>} DISTINCT([E Number]))

       +sum({<[S Flag]={1},LastMnthPerQtr={1},Num_Month = {$(=Max(Num_Month))},[DP Flag]={1}>}([P Count])),



       If (GetSelectedCount ([Year List]) > 0 and GetSelectedCount (Month) = 0 and GetSelectedCount (Quarter) = 0,



              count ({<[P Flag] ={1}, LastMnthPerQtr={1},[S Flag] = {1}>} DISTINCT([E Number]))

              +sum({<[S Flag]={1},LastMnthPerQtr={1},[DP Flag]={1}>}([P Count])),



              if (GetSelectedCount (Quarter) > 0,



                     count ({<[P Flag] ={1}, [S Flag] = {1}>} DISTINCT([E Number])))

                     +sum({<[S Flag]={1},[DP Flag]={1}>}([P Count])))

If nothing is selected it should show me counts from Last month last quarter.

Ex: for the month of 2011----Q1, MAR-1111 Q2 JUN- 2222, Q3 SEP- 3333, Q4 DEC-4444

For the month of 2012-------Q1, MAR-5555 Q2 JUN- 6666, Q3 SEP- 7777, Q4 DEC-8888 and so on.. until 2016 Q4 Oct

Default chart values for 2011 should be 4444 and for 2012 8888 and so on.... (Last month last quarter as default)

I can see every counts but I'm missing the 2016 counts, it is showing 0 counts (thought I've the data) and if select 2016, Quarter 4 it is showing me data for 2 months (until Oct).

I used

If (GetFieldSelections ([Year List]) = year(today()) ,

count ({<[P Flag] ={1},[Rolling 3]={1}, [S Flag] = {1}>} DISTINCT([E Number])))

As my latest yr filter but it is not coming up...

Can anyone please help me with this?

Update:

Below expression I'm using in text box to test and i'm getting counts but in bar chart i'm not.

if([Rolling 3]=1,

count({<[P Flag] ={1},[Rolling 3]={1},Num_Month = {$(=Max(Num_Month)-2)}, [Year List] = {$(=Max([Year List]))},[S Flag] = {1}>} DISTINCT([E Number])),

stalwar1‌ @

Thanks.

topic current quarter month counts in QlikView

current quarter month counts