Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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
Karl is right, (almost 🙂 )
You should use:
if(Dimensionality()=0, sum({$<User=>} total Doc),sum(Doc))
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.
Thanks Karl and Dennis, I got the result. Thanks a lot.
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.
I think your orginal formula is working correct, isn't it?
("Documents Reviewed"/"Total Review Hours")