Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joshibabu_are
Contributor
Contributor

sort order in straight table

Hi Guru;s

I want to sort country column based on total employee count in all locations.

example :BU-API

                Country - USA

           employee count in 5 locations in us is less when compared to ITA(ITALY).

So ITA Should show first in Country column

US Head Count:431---For Business Unit-API

ITA head Count 505------For Business Unit-API

here pivot table not preferable because iam going to use this table in Nprinting.Nprinting wont support pivot table.

Please find the attached qlikview file

Thanks,

Joshi

13 Replies
sunny_talwar

Looks better?

Updated: Use a calculated dimension like this

Dual(Country, Aggr(NODISTINCT Sum([Actial Headcount]), [Business Unit], Country))

View solution in original post

sunny_talwar

Not sure if you want me to delete the app and image once you have downloaded it. It seems that Location was scrambled in QlikView.... so that is why I ask

joshibabu_are
Contributor
Contributor
Author

yes please delete the app and image.

its working fine .thank you sunny.

can we achieve the same sort order with out calculated Dimension?

Iam using this created Table in Nprinting HTML Report ,here the issue is table showing correct result but

country column only showing grey background.

i am planning to post new thread any way

Thanks once again

Joshi

sunny_talwar

Updated my post to remove the qvf and the image