topic Re: Pivot table layout issue in QlikView

Pivot table layout issue

mayuriborse1 — Fri, 15 Nov 2024 23:46:50 GMT

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.

Re: Pivot table layout issue

Brett_Bleess — Tue, 27 Oct 2020 20:50:39 GMT

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

Re: Pivot table layout issue

marcus_sommer — Wed, 28 Oct 2020 15:12:50 GMT

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

Re: Pivot table layout issue

mayuriborse1 — Thu, 29 Oct 2020 11:48:48 GMT

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