Qlik Community

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 
Search instead for 
Did you mean: 
renjithpl
Specialist
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.?

Table 1 (no selection made)

UserDocTotal HoursProductivity
Neel9312.57.44
Henry2,1209522.32
Paul1,52189.516.99
Thomas74046.515.91
Total4,474243.562.66


I want it like below:

UserDocTotal HoursProductivity
Neel9312.57.44
Total4,474243.562.66


Thanks in advance.

Ranjit

1 Solution

Accepted Solutions
pover
Partner
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.

View solution in original post

6 Replies
pover
Partner
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.

renjithpl
Specialist
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

dennisnet
Partner
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

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
Specialist
Specialist
Author

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

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

But its sh0wing some wrong answer. Please correct me.

Thanks once again.

dennisnet
Partner
Partner

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

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