topic Re: Showing 2 main columns in a pivot table in QlikView

Showing 2 main columns in a pivot table

Anonymous — Wed, 15 Jan 2014 12:35:12 GMT

I have a pivot table showing invoiced values by stock code, i want to also show as default the customers part no when applicable. it obviously shows when you drop it down from the stock code, but i want it to constantly show... help? its a shame you cant print screen on here to show exactly what im trying to say...(see attachment)

Re: Showing 2 main columns in a pivot table

danieloberbilli — Wed, 15 Jan 2014 12:41:13 GMT

go on object properties, presentation tab, check Always fully expand

Re: Showing 2 main columns in a pivot table

kiranmanoharrode — Wed, 15 Jan 2014 12:41:16 GMT

Try Aggr() Function,

=Sum(AGGR(Sum(NetSalesValue),StockCode,Cus_part_no))

=Sum(AGGR(Sum(QtyInvoiced),StockCode,Cus_part_no))

Regards
Kiran Rode

+91 8976977897

Re: Showing 2 main columns in a pivot table

Anonymous — Wed, 15 Jan 2014 14:28:32 GMT

Yes i had already done that but it showed everything. I have now sorted it though, thank you both for your help