Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Display Total as the value of a Column

Hi Gurus,

I have a scenario where I need to display a total as the value of existing column and not the sum or average of all the columns.

The original data is like below:

Original Table.png

And I have converted to Pivot as per requirement as below


Now as the values for AM PM an ND is being calculated as the average, so the partial sum (Total) for Census Period is also showing as average of AM,PM and ND. 

Only for Census A,I want the total to be displayed as the value of ND only i.e. 30 and not 29 in the above case.Rest all Census can show the value as usual as they are showing now.

I can achieve this using set analysis but can't find any way to write it for the total. Any pointers will be highly appreciated.




Labels (3)
1 Reply

Create new Column Total in the expression add this: AM + PM + ND

Color up the column in grey and you should come to the output you wish.