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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
satyam285889
Contributor II
Contributor II

Calculation with filter

Hello all, 

So in my 'Total Units per Deals' 

my expression is: 

IF(ProductID=4
,COUNT({<[IsRetailDeal] = {1}, FinanceType = {'Cash', 'Finance'} >} DISTINCT Total LogID)
,IF(ProductID=9
,COUNT({<[IsRetailDeal] = {1}, FinanceType = {'Finance'} >} DISTINCT Total LogID)
,IF(ProductID=7
,COUNT({<[IsRetailDeal] = {1}, FinanceType = {'Lease'} >} DISTINCT Total LogID)
,COUNT({<[IsRetailDeal] = {1}, FinanceType = {'Cash', 'Finance','Lease'} >} DISTINCT Total LogID)
)))

 

Table looks like this: 

satyam285889_0-1655696067592.png

My question is, When I remove the filter selection off FIManagerName my value to changes to total for the group. I need to see ALL the FI managers and ONLY their totals not the whole group. 

 

Same Table with W/O FIManager selection: 

satyam285889_1-1655696347619.png

(I need to see ALL the FI managers and ONLY their totals not the whole group in one table )

0 Replies