MAX(TOTAL - is showing excluded rows

[vinieme12]

Hi,

Sum by each Account_Tiering works fine, i'm only seeing Account_Tiering as defined in Account_Tiering = p(TieringSelect)

but when I try to see max by these specific Account_Tiering , all other Account_Tierings are also shown in the straight table.

Normal SUM

sum({<

a_ActivityYear = {$(=vYearSelection)}

, a_ActivityMonth = {"<=$(vMonthSelection)"}

,Account_Tiering = p(TieringSelect)

>}

$(vWeightingRegion)

)

MAX Expression which is revealing all rows

MAX(TOTAL aggr(

                         sum({<a_ActivityYear = {$(vYearSelection)}

                          ,Account_Tiering = p(TieringSelect)

                           , a_ActivityMonth={"<=$(vMonthSelection)"}>}

                          $(vWeightingRegion))        

                                   , Account_Tiering)  )

I have a calculated dimension which I want to get rid of

stalwar1‌, help needed

[vinieme12]

Unwanted rows in Yellow

PS: I only have one dimension that is Account_Tiering

[vinieme12 · Accepted solution]

Strange Behaviour with Qlikview!!

I was trying the above in an existing object , but when I created the a new straight table with the same expressions it's working as expected