topic Re: Pivot table- expand all dimension values in QlikView

Pivot table- expand all dimension values

dseelam — Sat, 16 Nov 2024 02:08:32 GMT

Hello All,

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

attached QVW

Arthur_Fong — Thu, 24 Oct 2019 05:30:31 GMT

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 — Fri, 25 Oct 2019 14:47:59 GMT

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