# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Specialist

## Make Straight table "Total" row Stable

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.?

 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

Ranjit

1 Solution

Accepted Solutions
Partner

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.

6 Replies
Partner

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.

Specialist
Author

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

Partner

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

Let me know if this is clear else I will E-mail the Qlikview document to you.

Specialist
Author

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

Specialist
Author

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