Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Looks better?
Updated: Use a calculated dimension like this
Dual(Country, Aggr(NODISTINCT Sum([Actial Headcount]), [Business Unit], Country))
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
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
Updated my post to remove the qvf and the image