Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Hiding Column in Pivot Table

Hi All,

Please find the below data

  

id Typename salarysales
1AAAA1001000
2AAAA2002000
3BBBB3003000
4BCCC3004000
5CDDD3555000
6DEEE40060000

Without using macro i need output like below in Pivot Chart .I want to hide dimension Id.

 

Typenamesum(salary)sum(sales)
3003000
AAAA1001000
AAAA2002000

Thanks in advance

1 Solution

Accepted Solutions
Highlighted

Re: Hiding Column in Pivot Table

May be using Dual() function

Capture.PNG

View solution in original post

2 Replies
Highlighted

Re: Hiding Column in Pivot Table

May be using Dual() function

Capture.PNG

View solution in original post

Highlighted
Not applicable

Re: Hiding Column in Pivot Table

Thanks Sunny