Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use pivot table for this
isn't it possible to do in strength table?
pivot also it doesn't give count.
In strength table you dont have subtotals
Yes in pivot you can have Count
can you pls explan me how to get counts for above senario, i hv tried but fail.
See the solution I posted on this thread
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
I Used Dimensionality Function and Partial Sums in Presentation Tab
See this post
Partial Sums in straight table | Custom Labels in Pivot SubTotals