Solved: Re: Arranging column width in pivot table - Qlik Community

nikhilgarg · ‎2017-12-21

Hello All,

Is it possible to arrange column width in pivot table in QlikSense?

Anonymous · ‎2017-12-21

Without extension, create a new field.

Load * inline

[

Measure

Revenue

Quantity

]

Use column [Measure] as a filter.

Use the condition if(getselectedcount(Measure)=1, if (Measure='Revenue', sum(Revenue),sum(Quantity)),0)

If both Revenue and Quantity is selected or if nothing is selected, it'll display zero. Or you could change the last condition to display what you like.

View solution in original post

Anonymous · ‎2017-12-21

For the dimensions you can change it by simply clicking and dragging the column borders.

nikhilgarg · ‎2017-12-21

Hey,

You are correct but i need to resize the width of measures.

Anonymous · ‎2017-12-21

I don't think that can be done. You could use a table though.

nikhilgarg · ‎2017-12-21

Yup, using table as of now

nikhilgarg · ‎2017-12-21

Do we have any feature to show and hide pivot table as per condition in qlik sense?

Anonymous · ‎2017-12-21

What kind of a condition? You can create two pivots in two different sheets and use navigation buttons to switch between them.

nikhilgarg · ‎2017-12-21

I ahve a filter having values Revenue and Quantity. I want if Revenue selected then one pivot should be shown else other pivot showing quantity

Anonymous · ‎2017-12-21

Check this link:

http://branch.qlik.com/#!/project/56728f52d1e497241ae698a0

Create two pivots in two different sheets for Revenue and Quantity.

Insert two navigation buttons.

Set navigation action to 'Go to specific sheet'. Select the sheet. Do this for both buttons in two sheets.

nikhilgarg · ‎2017-12-21

Yup, that's possible with this extension but actually was trying without extension. ANyways thanks.