topic Re: Only total in straight table in Column in QlikView

Only total in straight table in Column

bsbernabe — Mon, 16 Jan 2017 09:02:52 GMT

Hi There,

There's any possible way that i can view only the total of Straight table in a simple way?

this is what i have:

this is what output that i need.

Regards Bing

Re: Only total in straight table in Column

dsharmaqv — Mon, 16 Jan 2017 09:23:04 GMT

silmplly do HO+Branch

Column(1)+Column(2)

Show only total in straight table

Re: Only total in straight table in Column

girirajsinh — Mon, 16 Jan 2017 09:31:12 GMT

sum(Total HO)+sum(Total Branch)..that will display 29 in Top row and all rows.

If you want 29 should be displayed only in Header and not in rows, then I don't think that is possible or atleast I don't know.

Re: Only total in straight table in Column

stabben23 — Mon, 16 Jan 2017 09:36:38 GMT

if( Dimensionality()=0,sum(Total Ho)+ sum(Total Branch),' ')

Re: Only total in straight table in Column

bsbernabe — Mon, 16 Jan 2017 09:59:06 GMT

Thanks Deepak Sharma, we are same expression

29 value is from the Total Mode to show the Total

that is why the total is 29

but if i didn't use the TOTAL Mode

This is the output below:

But what i need to show is Only Total like below screenshot.

Re: Only total in straight table in Column

stabben23 — Mon, 16 Jan 2017 10:08:03 GMT

use Expression Total and Dimensionality() function

Re: Only total in straight table in Column

ahaahaaha — Mon, 16 Jan 2017 14:17:16 GMT

Hi Bing,

In expression you want to hide and for text color use expression (adapt to your need)

if(Dimensionality()=1,argb(0,0,0,0), black())

Regards

Andrey

Re: Only total in straight table in Column

bsbernabe — Tue, 17 Jan 2017 02:38:04 GMT

Hello There Thank you so much for all your respond i really appreciate,

so now i simplify my concern cause base on my original post its not possible.

Here my another concern, There's any way so get the total of Amount using expression not using Total Mode.

Regards,

Bing

Re: Only total in straight table in Column

sunny_talwar — Tue, 17 Jan 2017 03:03:38 GMT

Would you be able to share a sample where you doing this? Its difficult to see what you might be doing and it might be efficient if we see it for our-self

Re: Only total in straight table in Column

bsbernabe — Tue, 17 Jan 2017 04:29:03 GMT

Here my QVW for reference of my Concern

Regards,

Bing

Re: Only total in straight table in Column

ahaahaaha — Tue, 17 Jan 2017 08:29:29 GMT

Which fields should be in dimensions and expressions of the table?

Regards,

Andrey

Re: Only total in straight table in Column

sunny_talwar — Tue, 17 Jan 2017 11:03:29 GMT

Is this what you want?

Used this expression:

=If(Dimensionality() = 0, Sum(WRKSum), ' ')

Re: Only total in straight table in Column

bsbernabe — Thu, 19 Jan 2017 01:45:08 GMT

Hello Sunny Thank you for your support, base on your expression what i need is the Total of Rows i do something but i know its not proper or correct cause I'm using Distinct to get the Total Row can you correct me

=Sum( aggr( sUM(Distinct If(DIVISIONCODE= 'HO', NetWorkDays(SUSDATEFR1,SUSDATETO1))),BADGENO,PENALTY) ) +

Sum( aggr( sUM(Distinct If(DIVISIONCODE= 'HO', NetWorkDays(SUSDATEFR2,SUSDATETO2))),BADGENO,PENALTY) )

Note Try to Use sample

0369 i got the correct Total but here at

0811 i got wrong Total

Best Regards,

Bing

Re: Only total in straight table in Column

sunny_talwar — Thu, 19 Jan 2017 02:55:35 GMT

Try this:

=Sum(Aggr(Sum(Distinct {<DIVISIONCODE = {'HO'}>} RangeSum(NetWorkDays(SUSDATEFR1,SUSDATETO1), NetWorkDays(SUSDATEFR2,SUSDATETO2))), BADGENO,SUSDATEFR1, SUSDATEFR2, SUSDATETO1, SUSDATETO2))

Re: Only total in straight table in Column

bsbernabe — Thu, 19 Jan 2017 03:45:08 GMT

Yes. Thank you Sunny I got it you such a great..