Make Straight table "Total" row Stable

[renjithpl]

Hi All,

If any selection is done, i want my "Total" row of straight table to be stable as it was when no selection is made. Is it possible.?

Table 1 (no selection made)

User	Doc	Total Hours	Productivity
Neel	93	12.5	7.44
Henry	2,120	95	22.32
Paul	1,521	89.5	16.99
Thomas	740	46.5	15.91
Total	4,474	243.5	62.66

I want it like below:

User	Doc	Total Hours	Productivity
Neel	93	12.5	7.44
Total	4,474	243.5	62.66

Thanks in advance.

Ranjit

[pover · Accepted solution]

In the expressions, put

if(dimensionality=0, sum({$<User=>} total Doc),sum(Doc))

Total should have a dimensionality of 0 and in a row with User the dimensionality is 1. For the total expression you should use total and ignore the selection of the User field.

Regards.

[renjithpl]

Hi Karl,

Thanks for the reply, but i am kind of confused, I have attached a sample application, please have a look at it, its in my first thread. Thanks a lot.

Regards

Ranjit

[Anonymous]

Karl is right, (almost 🙂 )

You should use:

if(Dimensionality()=0, sum({$<User=>} total Doc),sum(Doc))

For the expresion: Documents Reviewed

And

if(Dimensionality()=0, sum({$<User=>} total TotalHours), Sum (TotalHours))

For the expression : Total Review Hours

I tried to upload your file but I got an error.
Let me know if this is clear else I will E-mail the Qlikview document to you.

[renjithpl]

Thanks Karl and Dennis, I got the result. Thanks a lot.

[renjithpl]

HI Dennis,

I have one more query, regarding above.

I have a expression like this for productivity the formula for it is:

=Sum(Doc)/Sum(TotalHours)

Can you help me, how to show productivity,

I did something like this

=if(Dimensionality()=0, sum({$<User=>} total Doc/TotalHours), sum(Doc)/Sum (TotalHours))

But its sh0wing some wrong answer. Please correct me.

Thanks once again.

[Anonymous]

I think your orginal formula is working correct, isn't it?

("Documents Reviewed"/"Total Review Hours")