pivot table

[GraceGao]

Hi Experts,

can Qlik sense realize below layout?  Please advise. Thanks.

[eliran]

Hi,

It can work, the idea behind this is to create two inline fields that will hold the captions, and inside the expression you address them with if statement / peek.

For example

Load * INLINE [

TimeFrame

MTD

YTD

];

Load * INLINE [

Department

Sales

Distribution

];

The expression will be as follows

OB =

if(TimeFrame='MTD',

        if(Department='Sales',sum(SalesMTD_OB ),sum(DistributionMTD_OB ),

        if(Department='Sales',sum(SalesYTD_OB ),sum(DistributionYTD_OB ))

I hope it helps,

Eliran.