Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
A_PR
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

A_PR
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])))