Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

Arranging column width in pivot table

Hello All,

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

1 Solution

Accepted Solutions
adwitiya
Contributor

Re: Arranging column width in pivot table

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.

10 Replies
adwitiya
Contributor

Re: Arranging column width in pivot table

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

nikhilgarg
Contributor III

Re: Arranging column width in pivot table

Hey,

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

adwitiya
Contributor

Re: Arranging column width in pivot table

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

nikhilgarg
Contributor III

Re: Arranging column width in pivot table

Yup, using table as of now

nikhilgarg
Contributor III

Re: Arranging column width in pivot table

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

adwitiya
Contributor

Re: Arranging column width in pivot table

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

nikhilgarg
Contributor III

Re: Arranging column width in pivot table

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

adwitiya
Contributor

Re: Arranging column width in pivot table

Check this link:

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

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

Insert two navigation buttons.

sheet navigation1.JPG

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

sheet navigation.JPG

nikhilgarg
Contributor III

Re: Arranging column width in pivot table

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

Community Browser