topic Total in staright Table in QlikView

Total in staright Table

qolkaram — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Total in staright Table

Frank_Hartmann — Fri, 27 Sep 2019 14:23:41 GMT

try like this:

Expression:

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

Re: Total in staright Table

qolkaram — Fri, 27 Sep 2019 15:05:56 GMT

Thanks Frank, it is working 🙂