Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Add sub totals in straight table

Hi,

I have created below straight table in qlikview.

My table looks like below,

NameCountrySalary
Test AbcUS12222
HHHUS758528
eefefUK858
4f4f4fUK88528
4f4fUK85282
4f4f4fJapan8528285

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

Thanks

8 Replies
ecolomer
Master II
Master II

Use pivot table for this

anuradhaa
Partner - Creator II
Partner - Creator II
Author

isn't it possible to do in strength table?

pivot also it doesn't give count.

ecolomer
Master II
Master II

In strength table you dont have subtotals

Yes in pivot you can have Count

anuradhaa
Partner - Creator II
Partner - Creator II
Author

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

vinieme12
Champion III
Champion III

See the solution I posted on this thread

Straight/Pivota Table

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

I Used Dimensionality Function and Partial Sums in Presentation Tab

vinieme12
Champion III
Champion III

See this post

Partial Sums in straight table | Custom Labels in Pivot SubTotals

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.