If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
can Qlik sense realize below layout? Please advise. Thanks.
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.
Load * INLINE [
The expression will be as follows
if(Department='Sales',sum(SalesMTD_OB ),sum(DistributionMTD_OB ),
if(Department='Sales',sum(SalesYTD_OB ),sum(DistributionYTD_OB ))
I hope it helps,