Column width in pivot created as a visualization on the fly

_jespers_ — Sat, 16 Nov 2024 01:23:16 GMT

I'm having a problem with the column width for a pivot table created as a visualization on the fly. The same problem also occurs when I'm creating the pivot table with the standard Qlik Sense pivot table chart, but my guess was that I could have more control over how the data was being displayed if I created the pivot table as an extension.

In the pivot table I have the dimensions Date and ID to the left and the dimension Question and the measure Answers to the right. The problem is that the dimension Question is only displaying 1 question at the time, so I need to scroll to the right to see the rest of the questions.

How I want it to behave is that multiple questions is being displayed next to each other so I don't have to scroll to the right.

There is a property called columnWidths (link) that you can set in the qHyperCubeDef, but I don't get it to work and I'm actually not even sure what it does or if it will solve my problem.

Any ideas how I can get this to work or how I can achieve multiple questions, side by side?

app.visualization.create( 'pivot-table', [ 'Date', 'ID', 'Question', '=Only(Answers)' ], { "showTitles": true, "title": "Example", "qHyperCubeDef": { qNoOfLeftDims: 2, qAlwaysFullyExpanded: true } } ).then(function(vis){ vis.show("QV01"); });

Thank you!

Re: Column width in pivot created as a visualization on the fly

linnakry — Tue, 15 Jun 2021 09:31:46 GMT

I have not tried with pivot-table, but for straight table, you can include columnWidths properties in the qHyperCubeDef,

..., { "showTitles": true, "title": "Example", "qHyperCubeDef": { "qNoOfLeftDims": 2, "qAlwaysFullyExpanded": true, "columnWidths":[100,100, 100, 100] } } ...

topic Re: Column width in pivot created as a visualization on the fly in Integration, Extension & APIs

Column width in pivot created as a visualization on the fly

Re: Column width in pivot created as a visualization on the fly