Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qolkaram
Contributor III
Contributor III

Total in staright Table

Hi,

in a straight table, I filtered some rows but in total, I want to count them in the total sum .is there any way to do this.i listed working day revenue but in total, I want to sum up all revenue including weekeds. any idea to help me to do this.

 

 

 

 

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

try like this:

Expression:

If(Dimensionality()=0, sum(Total Value), sum(Value))

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

try like this:

Expression:

If(Dimensionality()=0, sum(Total Value), sum(Value))

qolkaram
Contributor III
Contributor III
Author

Thanks Frank, it is working 🙂