Pivot table layout issue

[mayuriborse1]

Hello,

I am not able to create below Pivot layout as shown in attached picture. If I consider Day in dimension, it will be applicable to other expressions too. Can anybody help me with this ? Not able to move highlighted dimension as per attached picture. 

[Brett_Bleess]

Best I have are the following two Design Blog posts:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Not sure if that will put you on the right track or not, but hopefully will give you some ideas.

Regards,
Brett

[marcus_sommer]

It's not possible - at least not with the classical approaches of creating a chart respectively to load the data within the datamodel. Alternatives could be to create for each column an own expression or to create an appropriate dimension within the datamodel (of course both approaches will have some disadvantages).

Usually much better is instead to use multiple objects to show these information.

- Marcus

[mayuriborse1]

Thank you for your help. I have got the solution using creating backend dimension and Pick-match on front.