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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AndyC
Contributor III
Contributor III

Pivot Table - Hide Column values depending upon previous row dimension value?

I've got a pivot, with some columns (both dimensions and measures) that are per Partcode, and other that are per line. I want to leave the column blank if it is a repeat of the previous row.

E.g. for this part, I want to exclude rows 2-4 for the highlighted values if the partcode is the same as the previous row. Those with the red-ringed columns are dimensions  and the others are measures.

AndyC_2-1739191862650.png

Is there a way to do this?

 

 

Labels (2)
1 Solution

Accepted Solutions
AndyC
Contributor III
Contributor III
Author

Answered my own question!

 

If(Above(TOTAL Partcode)=Partcode,Null(), <Formula for Column Measure>)

View solution in original post

1 Reply
AndyC
Contributor III
Contributor III
Author

Answered my own question!

 

If(Above(TOTAL Partcode)=Partcode,Null(), <Formula for Column Measure>)