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

How to display null Value in bottom of the Pivot Table

Lakshminarayanan_J — Sat, 16 Nov 2024 01:51:37 GMT

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 Unit	Sub Team	Brand
Total
YYYY		Total
YYYY		a
YYYY		b
YYYY		c
YYYY		d
YYYY	Bien-etre	Total
YYYY	Bien-etre	A
YYYY	Bien-etre	B
YYYY	Bien-etre	C
YYYY	Bien-etre	D

Expected Result

Business Unit	Sub Team	Brand
Total
YYYY	Bien-etre	Total
YYYY	Bien-etre	A
YYYY	Bien-etre	B
YYYY	Bien-etre	C
YYYY	Bien-etre	D
YYYY		Total
YYYY		a
YYYY		b
YYYY		c

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

Lakshminarayanan_J — Tue, 26 Nov 2019 10:25:05 GMT

Can you please help me out on this above issue

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

carg1 — Tue, 26 Nov 2019 11:02:08 GMT

Hi,

can You make a screenshot of Your sorting options.

BR

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

Brett_Bleess — Mon, 09 Dec 2019 19:14:52 GMT

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/1470262

Regards,
Brett