Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III
Author

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III
Author

Unwanted rows in Yellow

PS: I only have one dimension that is Account_Tiering

max_Total.JPG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III
Author

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.