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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jamessmith99
Contributor II
Contributor II

Total different than subtotal

I want the pivot table Totals to display $102,160 and the Employees to display ‘Confidential’. Can this expression be changed to do that?

IF(Sum({$<Employee={'Mark Willams','Thomas Nguyen'}>}Salary)= 0,'Confidential'))

Employee

Salary

Totals

$102,160

Mark Willams    

Confidential

Thomas Nguyen

Confidential

 

1 Solution

Accepted Solutions
sunny_talwar

May be something like this

If(Dimensionality() = 0,
Sum({$<Employee = {'Mark Willams', 'Thomas Nguyen'}>} Salary),
'Confidential')

View solution in original post

2 Replies
jyothish8807
Master II
Master II

Can you please share a sample data you have ? Is salary of two employees "0" in  the data ? And what is total,  is it a entry in the data or is it total of salaries of all employees ?

Best Regards,
KC
sunny_talwar

May be something like this

If(Dimensionality() = 0,
Sum({$<Employee = {'Mark Willams', 'Thomas Nguyen'}>} Salary),
'Confidential')