Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
qvqfqlik
Creator
Creator

Help with Aggr () not working

I am trying to aggregate the total value of the count result as below. but this is not happening

Sum(Aggr(Count({<RECORD_TYPE = {ORDERED, SHIPPED}>} DISTINCT BILLTOCUSTEDP),OFFERNUM))

I am trying to aggregate the same offernumber

below is before aggregating:

aggr2.JPG

below is after aggregating, the total should be 19 , but it still shows as 18

aggr1.JPG

25 Replies
qvqfqlik
Creator
Creator
Author

Thanks Sunny , I opened the app you sent , and seeing as below, The last total is still 0 when I opened.

Also not aggregating as you have used Dimensionality='6'

newpromo1.JPG

when I use Dimensionality <=5, its aggregating, but the last Total row is still 0

newpromo2.JPG

sunny_talwar

What tab are you looking at? I am looking at Promo Results tab and Offer/Promo Demand?

Capture.PNG

qvqfqlik
Creator
Creator
Author

Even In Promo results tab I am seeing 0

promotab1.JPG

sunny_talwar

Just out of curiosity, can you post a screenshot of the file that I have attached within this post

Capture.PNG

qvqfqlik
Creator
Creator
Author

here is the screen of the file you attached when I opened in my computer

promocuri.JPG

sunny_talwar

I have no idea.....