Discussion board where members can get started with Qlik Sense.
Is it possible to arrange column width in pivot table in QlikSense?
Go to Solution.
Without extension, create a new field.
Load * inline
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.
For the dimensions you can change it by simply clicking and dragging the column borders.
You are correct but i need to resize the width of measures.
I don't think that can be done. You could use a table though.
Yup, using table as of now
Do we have any feature to show and hide pivot table as per condition in qlik sense?
What kind of a condition? You can create two pivots in two different sheets and use navigation buttons to switch between them.
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
Check this link:
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.
Yup, that's possible with this extension but actually was trying without extension. ANyways thanks.