Maximum year in a Quarter

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

Hello,

I'd like to get an set expression for

Maximum month in current quarter

If 2011 year is selected, I want to see counts for Q1, Q2, Q3, Q4 ( in Q1 I want the count of only March, in Q2 only June.....)

Currently I'm getting Counts of 1st month for each quarter.

Below is my expression...

If (GetSelectedCount (Month) > 0 or GetSelectedCount (Quarter) > 0,

count ({<Field1 ={1}, Field2={1}>} DISTINCT(Field2)),

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

If (GetFieldSelections ([Year List]) = year(today()) and GetSelectedCount (Month) = 0 and GetSelectedCount (Quarter) = 0,

count ({<Field1 ={1} , [Month Number] = {01},Field2 = {1}>} DISTINCT(Field3)),

If (GetSelectedCount (Month) = 0 and GetSelectedCount (Quarter) = 0,

count ({<Field1={1}, [Month Number] = {03,06,09,12},Field2 = {1}>} DISTINCT(Field3)),

)),

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

count ({<Field1 ={1}, [Month Number] = {01},Field2= {1}>} DISTINCT((Field3)),

If (GetSelectedCount (Month) = 0 and GetSelectedCount (Quarter) = 0,

count ({<Field1 ={1}, [Month Number] = {$(=Max([Month Number]))},Field2= {1}>} DISTINCT(Field3))

,

//--

count ({<Field1 ={1}, [Month Number] = {$(=Max([Month Number]))}, Field2 = {1}>} DISTINCT(Field3))))))

+sum({<Field1={1},[Month Number] = {$(=Max([Month Number]))},Field4={1}>}(Field5))

stalwar1‌

Thanks.

topic Maximum year in a Quarter in QlikView

Maximum year in a Quarter