Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
samir_bihari
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

Pivot.png

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.

 

Thanks

Samir

Labels (3)
1 Reply
MindaugasBacius
Partner
Partner

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.