Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ndeeleysww
Contributor

Remove rows from Pivot Table

Hi all,

I'm creating a pivot table and need to remove some rows from the table. For example, in my data I have many types of cost header - such as Labour, Equipment, Materials. If I want to show just the Labour and Equipment, how do I not show the Materials rows, or any rows underneath if I add to the pivot?

I don't want to remove the data I don't need on load as I'd like to reference it later in the app, but if it is possible to hide this data with an expression then that would be a great help.

Thanks

Neil

1 Solution

Accepted Solutions
ndeeleysww
Contributor

Re: Remove rows from Pivot Table

Sorry - dim of me! I used the match function to hide the rows:

if(match(CostHeader, 'LABOUR', 'EQUIPMENT'), CostHeader)

5 Replies
ndeeleysww
Contributor

Re: Remove rows from Pivot Table

Sorry - dim of me! I used the match function to hide the rows:

if(match(CostHeader, 'LABOUR', 'EQUIPMENT'), CostHeader)

Re: Remove rows from Pivot Table

I am guessing that cost header would be your dimension and if that's true you can use calculated dimension:

If(Match([cost header], 'Labour', 'Equipment'), [cost header]) and then you can Suppress the Null Values for this dimension.

Best,

Sunny

Re: Remove rows from Pivot Table

Is the issue resolved then?

ndeeleysww
Contributor

Re: Remove rows from Pivot Table

Yes - finally figured that one out! Thanks for your reply.

Re: Remove rows from Pivot Table

No Problem! I am glad that you got what you needed.

Best,

Sunny

Community Browser