Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
preeti1
Contributor III
Contributor III

Total to be repeated in all rows

Hi All,

I want the total of a column to be shown in another column.

Please help me write the expression for Total column.

preeti1_0-1696344052101.png

 

Labels (1)
2 Replies
Mark_Little
Luminary
Luminary

Hi

SUM(<Total>Value)

look up the total function in the help if you need more help

preeti1
Contributor III
Contributor III
Author

I have used a set expression for column C - Values

count({<task_name*={'ABC'},reject_reason*=-{'Unspecified'}>}distinct([document_number]))

 

I tried doin the below, it dusnt work:

sum(TOTAL count({<task_name*={'ABC'},reject_reason*=-{'Unspecified'}>}distinct([document_number])))