topic Make Straight table "Total" row Stable in QlikView

Make Straight table "Total" row Stable

renjithpl — Mon, 06 Dec 2010 07:29:36 GMT

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

Make Straight table "Total" row Stable

pover — Tue, 07 Dec 2010 02:57:49 GMT

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.

Make Straight table "Total" row Stable

renjithpl — Tue, 07 Dec 2010 07:24:19 GMT

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

Make Straight table "Total" row Stable

Anonymous — Tue, 07 Dec 2010 11:19:55 GMT

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.

Make Straight table "Total" row Stable

renjithpl — Tue, 07 Dec 2010 14:19:16 GMT

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

Make Straight table "Total" row Stable

renjithpl — Wed, 08 Dec 2010 06:20:03 GMT

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.

Make Straight table "Total" row Stable

Anonymous — Wed, 08 Dec 2010 08:18:36 GMT

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

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