Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Esteemed Contributor II

MAX(TOTAL - is showing excluded rows

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

1 Solution

Accepted Solutions
Highlighted
Esteemed Contributor II

Re: MAX(TOTAL - is showing excluded rows

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

View solution in original post

2 Replies
Highlighted
Esteemed Contributor II

Re: MAX(TOTAL - is showing excluded rows

Unwanted rows in Yellow

PS: I only have one dimension that is Account_Tiering

max_Total.JPG

Highlighted
Esteemed Contributor II

Re: MAX(TOTAL - is showing excluded rows

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

View solution in original post