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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jduluc12
Creator
Creator

How to add fixed values in the total of pivot table

Hi

I want to add some fixed values to the total row of the pivot table.

the expression looks something like this

if(RowNo()<>0 and not IsNull(RowNo()), sum({<Type={'A'}>}Amount),  sum({<Type={'A'}>}Amount) + 300 )

This ends up bringing all dimensions even if their Type is not 'A' and shows 300 as the values in the column.

Is there any better way to achieve it?

Thanks

Jean

Labels (1)
0 Replies