Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

How to display null Value in bottom of the Pivot Table

Dear All,

 

I need to display the null value in the sub team @ the bottom of the pivot table ,i have tried out the sorting option but it is not working ,kindly help me out on this !!

Current Result

Business UnitSub TeamBrand
Total  
YYYY Total
YYYY a
YYYY b
YYYY c
YYYY d
YYYYBien-etreTotal
YYYYBien-etreA
YYYYBien-etreB
YYYYBien-etreC
YYYYBien-etreD

Expected Result

Business UnitSub TeamBrand
Total  
YYYYBien-etreTotal
YYYYBien-etreA
YYYYBien-etreB
YYYYBien-etreC
YYYYBien-etreD
YYYY Total
YYYY a
YYYY b
YYYY c
3 Replies
Highlighted
New Contributor

Re: How to display null Value in bottom of the Pivot Table

Can you please help  me out on this above issue

Highlighted
New Contributor III

Re: How to display null Value in bottom of the Pivot Table

Hi, 

can You make a screenshot of Your sorting options. 

BR

Highlighted
Digital Support
Digital Support

Re: How to display null Value in bottom of the Pivot Table

Best I have that may be helpful is the following Design Blog post, and believe you will have to do an expression on this one...

https://community.qlik.com/t5/Qlik-Design-Blog/The-sortable-Aggr-function-is-finally-here/ba-p/14702...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.