Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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.

 

 

 

 

Labels (1)
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 🙂