Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ishaan_Kumar
Contributor III
Contributor III

Bypassing while using Aggr in Pivot table

=sum(aggr
(count({< CalendarMonthNum=,CalendarYear=,Date=, BookingStatus={'Booking','Booked','Car Allocated'}>}distinct(Booking_ID)),
RM_Name,AM_Name,DealerCode,City_Name,Model,ModelCode))

The above measure is an expression Pivot Table.
I have 2 doubts :-

1) This expression is not able to bypass the fields.

2) I want to add 1 more dimension in my pivot . However, whenever I add the same in aggr function along with rest of the fields , my total value changes . 

Labels (2)
1 Reply
ali_hijazi
Partner - Master II
Partner - Master II

include the by passing in the sum:
sum({<CalendarMonthNum=,CalendarYear=,Date=>}aggr(count({<CalendarMonthNum=,CalendarYear=,Date=,....

I can walk on water when it freezes