Pivot table format issue in QlikSense

AW97 — Tue, 04 Apr 2023 09:26:54 GMT

I’m trying to port over our IT holiday calendar app from QlikView to Qliksense, but I am having difficulty building the pivot table in Qliksense. The main issue is trying to create the same format for the pivot table but the line break char(10)/(13) trick that works in QlikView doesn’t in Qliksense. Has anyone come across anything similar or have a workaround to display like QlikView?

Re: Pivot table format issue in QlikSense

Or — Tue, 04 Apr 2023 09:50:36 GMT

For the pivot table, unfortunately not. While the pivot header will respect a new line within a string quote, lines won't in my experience.

You might be able to get something reasonably similar by using multiple regular tables stacked up next to each other, each describing a single day of the week. Regular tables will take chr(10) for a new line, as well as new lines contained within a string quote. You'll probably need to pad new lines into each table to ensure every cell is the same height.

topic Re: Pivot table format issue in QlikSense in App Development

Pivot table format issue in QlikSense

Re: Pivot table format issue in QlikSense