Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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
jagan
Partner - Champion III
Partner - Champion III

Hi,

If you don't want in the chart then you can simply remove that dimension in the chart, if you are doing any calculations based on that used you can manage it with Aggr().  If you come up with sample data and expected output then it would be easier to give solution.

Regards,

Jagan.

magnuslander
Partner - Contributor II
Partner - Contributor II

Did you ever find a solution to this? I'm working with the same problem.