topic Re: Total In Straight table in QlikView

Total In Straight table

sunil1989 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Thanks in advance,

My requirement is suppose i have 10 location in straight table , but i have to show only one location with there expression ,

but subtotal should have sum of all 10 rows.

bellow All Locations is my Subtotal row.

Summary	#Ordered	#Short	#Sub	#All	%Short	%Sub	%All	% Avail
All Locations	4076	177	126	303	4.34%	3.09%	7.43%	98.30%
132 Delhi	468	27	18	45	5.77%	3.85%	9.62%	99.20%

Thanks,

Sunilkumar

Re: Total In Straight table

sunny_talwar — Thu, 08 Jun 2017 14:06:08 GMT

May be use Dimensionality() function

If(Dimensionality() = 0, Sum(Measure), Sum({<Location = {'132 Delhi'}>} Measure)

Re: Total In Straight table

vicobi123 — Thu, 08 Jun 2017 15:00:37 GMT

Is this for QlikView or Qliksense. In Qliksense, the straight table gives you the option to add "Total"

Regards,

Vic

Re: Total In Straight table

sunil1989 — Thu, 08 Jun 2017 15:19:49 GMT

It's for qlikview.

Re: Total In Straight table

sunny_talwar — Thu, 08 Jun 2017 15:22:00 GMT

Did you try my suggestion?

Re: Total In Straight table

johnw — Thu, 08 Jun 2017 22:53:24 GMT

Possible data model solution.

LocationGroups:
LOAD 'All Locations' as LocationGroup
,text(fieldvalue('Location',recno())) as Location
AUTOGENERATE fieldvaluecount('Location')
;
CONCATENATE LocationGroups
LOAD * INLINE [
LocationGroup,Location
132 Delhi,132 Delhi
];

Use LocationGroup as your dimension instead of Location, no totals in the chart, no change to your expressions.

Sunny's solution is probably more in line with what you want. Just tossing out another possibility.

Re: Total In Straight table

sunil1989 — Fri, 09 Jun 2017 07:59:30 GMT

I tried but its not working , thanks.

Re: Total In Straight table

sunny_talwar — Fri, 09 Jun 2017 09:04:34 GMT

1st of all, I apologize, I missed a parenthesis in my first expression. Not sure if that was the reason behind it not working. I have created a small example for you to see....

Table:

LOAD * Inline [

Location, #Ordered

Loc1, 40

Loc2, 50

Loc3, 60

Loc4, 468

];

Here I would like to see Total row and Loc4 row.

Dimension

Location

Expression

If(Dimensionality() = 0, Sum(#Ordered), Sum({<Location = {'Loc4'}>} #Ordered))

I am attaching the qvw sample for you to take a look at