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

Announcements
Join us in Toronto Sept 9th 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>)