Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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