Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove the column of one dimension in pivot table

Hi all,

I have a pivot table and it has two dimensions date and used. How can i move the column of used? I dont want it show in my report....

Thanks

Jelly

Capture.PNG

11 Replies
amit_saini
Master III
Master III

Jelly,

This is not possible in pivot table but you can hide this in straight table.

Thanks,

AS

mov
Champion III
Champion III

Just make it as narrow as possible, and replace the label with blank text.

mohammadkhatimi
Partner
Partner

Hi...

In label "Used" dimension...add blank spaces..

Regards,

Mohammad

Not applicable

in Dimension Label.. make it blank and then drag the column to as narrow as possible.

Not applicable

Hi Jelly,

As per my understanding I guess that you want to remove the column "Used" from the report. In case you are looking to remove it completely from your report (and do not want to group the calculations with its field values) then simply remove it from the dimensions list.

Else in case if you want to hide it temporarily or permanently you can do that as below

1. Just open the Chart Properties and go to the Dimensions tab.

2. Click on the Used dimension field and check the enable conditional dialogue box

3. You can give a condition as 1=0 and the “Used” dimension will remain hidden.

I hope this will help

Thanks,

Amey

Not applicable

Hi

I have tried this way, but the blank text could not be narrow as small as the cell in the report. So some how the line under the cell has been cover and could not show normally....

Could any other way to fix it?

Thanks

Jelly

Not applicable

Hi

I have tried this way, but the blank text could not be narrow as small as the cell in the report. So some how the line under the cell has been cover and could not show normally....

Could any other way to fix it?

Thanks

Jelly

Not applicable

Hi

I have tried this way, but the blank text could not be narrow as small as the cell in the report. So some how the line under the cell has been cover and could not show normally....

Could any other way to fix it?

Thanks

Jelly

mohammadkhatimi
Partner
Partner

Please post sample data..