topic Re: Add sub totals in straight table in QlikView

Add sub totals in straight table

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

Hi,

I have created below straight table in qlikview.

My table looks like below,

Name	Country	Salary
Test Abc	US	12222
HHH	US	758528
eefef	UK	858
4f4f4f	UK	88528
4f4f	UK	85282
4f4f4f	Japan	8528285

I Want to display number of people belongs to each country ( sub total group by country). Is this possible?

Thanks

Re: Add sub totals in straight table

ecolomer — Sat, 01 Apr 2017 05:56:18 GMT

Use pivot table for this

Re: Add sub totals in straight table

anuradhaa — Sat, 01 Apr 2017 06:04:12 GMT

isn't it possible to do in strength table?

pivot also it doesn't give count.

Re: Add sub totals in straight table

ecolomer — Sat, 01 Apr 2017 06:26:03 GMT

In strength table you dont have subtotals

Yes in pivot you can have Count

Re: Add sub totals in straight table

anuradhaa — Sat, 01 Apr 2017 06:35:32 GMT

can you pls explan me how to get counts for above senario, i hv tried but fail.

Re: Add sub totals in straight table

vinieme12 — Sat, 01 Apr 2017 07:02:32 GMT

See the solution I posted on this thread

Straight/Pivota Table

Re: Add sub totals in straight table

Anil_Babu_Samineni — Sat, 01 Apr 2017 09:12:32 GMT

No, His intention is change your object from Straight to Pivot object and then go to presentation of country dim then use Partial sum. it work as Group by clause in sql of total

Re: Add sub totals in straight table

Anonymous — Sat, 01 Apr 2017 12:32:28 GMT

I Used Dimensionality Function and Partial Sums in Presentation Tab

Re: Add sub totals in straight table

vinieme12 — Tue, 04 Apr 2017 11:19:23 GMT

See this post

Partial Sums in straight table | Custom Labels in Pivot SubTotals