MAX(TOTAL - is showing excluded rows

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

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

Re: MAX(TOTAL - is showing excluded rows

vinieme12 — Thu, 04 Aug 2016 08:38:40 GMT

Unwanted rows in Yellow

PS: I only have one dimension that is Account_Tiering

vinieme12 — Thu, 04 Aug 2016 09:29:24 GMT

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