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: 
dseelam
Creator II
Creator II

Pivot table- expand all dimension values

Hello All,

can i get same columns as straight table in pivot even after summing records.

 

Capture.PNG

 

attached QVW 

Labels (3)
2 Replies
Arthur_Fong
Partner
Partner

Expression should be :

sum({<cust={'b'},series={'north east'}>}units)

But your table does not have any data for cust B, series north east.

So the result will be 0 in this case.

 

dseelam
Creator II
Creator II
Author

Hello Arthur,

 

I don't want other column with data I want to expand both a and b customer with all series regardless of null units and price