Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
j_tupper
Contributor
Contributor

Showing 2 main columns in a pivot table

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)

3 Replies
danieloberbilli
Specialist II
Specialist II

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

Capture444.PNG.png

kiranmanoharrode
Creator III
Creator III

Try Aggr() Function,

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

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

Regards
Kiran Rode

+91 8976977897

j_tupper
Contributor
Contributor
Author

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