Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.