Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Is it possible to arrange column width in pivot table in QlikSense?
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.
For the dimensions you can change it by simply clicking and dragging the column borders.
Hey,
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:
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.
Yup, that's possible with this extension but actually was trying without extension. ANyways thanks.